pilot-db-list

Re: [pilot-db-list] New reports

[Scott W. <swa...@my...>]

On Wed, 20 Mar 2002, Fab wrote:

> 	Hello all.
> 
> 
> 	I got a crash with 1.0.0 after adding a calculated
> field. The addition worked well, but I didn't put the
> formula because I hadn't yet thought about it (I wanted to
> get it in through memo). Then each time I tried to "database
> design", I got a crash : memory.mgr, line 4340, NULL handle.
> The field appeared well in the list view stating [n/a] which
> was the expected behaviour.
> 	So I reinstalled my backup base and all is fine again.
> 	I retried the process but with a formula and all worked ok.


	Ok, I look into this, I've been thinking that this would come up 
at somepoint....


> 
> 
> 	Another one, especially for Scott, sorry :-)
> 	I had a syntax error in a formula, so I tried to get
> rid of a space. No chance, so I inserted it back. But in the
> process, I lost all the part after the space. The formula
> was truncated visually and in the buffer (I know that because
> of the error reported when compiling : unexpected end).
> 	Well, I have the formula in a memo, so no real lost :-)

	This one might be more tricky, but I know why it happens.  I'll 
see what I can do.

	-Scott

[pilot-db-list] New reports, next

[Fab <kr...@bi...>]

	Two other things with sorting :

	I have a inter-records calculated field which resembles
the exemple in the doc : accumulated times according to values
of a list field. The calculations are fine, but the sort given
by (sort n 1) is not the same as the one performed by the little
box you get by taping on the field header. So results in viexs
are hard to interpret. Do you plan, Scott, to add the ability (in
a future release, I mean :-) to write something like
	(sort n 0|1 [, m 0|1 ...]) ?

	With the inter-records fields, I can't anymore use the
sort menu : records get ressorted according to calculated fields
after the menu sort has occured.

	HTH.

	BTW, Marc, where can I get the gui you're writing ?
I downloaded the last sourceforge distro, but it didn't show
it. Do I need to get CVS ?

	Fab.

[pilot-db-list] New reports

[Fab <kr...@bi...>]

	Hello all.


	I got a crash with 1.0.0 after adding a calculated
field. The addition worked well, but I didn't put the
formula because I hadn't yet thought about it (I wanted to
get it in through memo). Then each time I tried to "database
design", I got a crash : memory.mgr, line 4340, NULL handle.
The field appeared well in the list view stating [n/a] which
was the expected behaviour.
	So I reinstalled my backup base and all is fine again.
	I retried the process but with a formula and all worked ok.


	Another one, especially for Scott, sorry :-)
	I had a syntax error in a formula, so I tried to get
rid of a space. No chance, so I inserted it back. But in the
process, I lost all the part after the space. The formula
was truncated visually and in the buffer (I know that because
of the error reported when compiling : unexpected end).
	Well, I have the formula in a memo, so no real lost :-)

	Fab.

[pilot-db-list] palm-db-tools

[marc-chalain <mar...@wa...>]

do somebody try the GUI application on Linux?

[pilot-db-list] please unsubscribe

[<MZu...@ao...>]

please drop me from the mailing list

RE: [pilot-db-list] Filter on Boolean Field - thinkDB

[KANE P. (CA) <Pet...@er...>]

I've been doing that for a while now. Works fine.

-----Original Message-----
From: Scott Wallace [mailto:swa...@my...]
Sent: Tuesday, 19 March 2002 6:25
To: Melvin Mudgett-Price
Cc: pil...@li...
Subject: Re: [pilot-db-list] Filter on Boolean Field - thinkDB



> How do I filter in a boolean field. I want to only show records where a
> field called "completed" is checked.

	I think that the string representation for a boolean 'true' field 
is '1', that's the way it looks in my copy of the source code.

	So try filtering on that criterion

> 
> Is there a plugin to allow viewing of thinkDB files?
> 

	No.


> Thanks in advance.
> 
> Melvin Mudgett-Price
> 
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

-- 





This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062 
Ergon Energy Pty Ltd      ABN 66 078 875 902

RE: [pilot-db-list] Build of DB 1.0 for Handera

[Craig B. <sys...@ca...>]

Pardon? It's all there.  Install the latest version, and the J-file and
Mobile DB plugins from the plugins folder, and the Handera and
English-help overlays from the overlays folder.  It's all built, you just
need to double click and install them.

>-----Original Message-----
>From: pil...@li...
>[mailto:pil...@li...]On Behalf Of Norman
>Wolfe
>Sent: Tuesday, March 19, 2002 10:30 AM
>To: pil...@li...
>Subject: [pilot-db-list] Build of DB 1.0 for Handera
>
>
>Has someone out there built DB 1.0 in English for the
>Handera with J-File and Mobile DB support? If so, will you
>share it with me at:
>nor...@ao...?
>
>Or, is there an FTP site where various builds are posted for
>downloading?
>
>Thanks for your help
>Norm Wolfe
>
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>

Re: [pilot-db-list] How do I set up a calculated field

[Andrew N. de la T. <ade...@qw...>]

Scott,
Thank you for your prompt response.  Is it possible to access the log=20
function from a shared library such as Mathlib 1.1.  It is used in most=20=

PalmOS scientific calculators.  It is also an opensource app covered=20
under GNU.   Here is the download site.
http://www.versiontracker.com/moreinfo.fcgi?id=3D185&db=3Dpalm

Andrew

On Tuesday, March 19, 2002, at 06:31 AM, Scott Wallace wrote:

>
>> I need to set up a calculated field using the addition of several log
>> expressions to calculate a score(MELD)  assessing the severity of
>> illness in patients with liver disease awaiting liver =
transplantation.
>>
>> The calculated field is as follows:
>>
>> ((0.957* Log(Case(Creatinine =E2=89=A5 4, 4, Dialysis  =3D=20
>> "YES",4,Creatinine))) +
>> (1.12 * Log(INR)) + (0.378 * Log(Bilirubin)) + 0.643) * 10
>
>
>
> 	Sadly, this is beyond the current abilities of db.
> Including a function such as Log() would require installing an=20
> additional
> math library on most devices, and is not supported at this point.  If
> there is enough support, we can consider adding support for these=20
> complex
> math operations.
>
> 	-Scott
>
>
>
>>
>> Addtitional condition are
>> 1. if creatinine > 4, max creatinine can only be 4
>> 2. if patient was on dialysis within 2 weeks, creatinine will equal 4
>> 3. if patient has a liver cancer and its size is less than 1 cm in
>> diameter the total score is 24
>> 4. if patient has a liver cancer and its size is greater than 1 cm =
the
>> total score is 29
>>
>>
>> Any help with information on script writing  in pilot-db will be=20
>> greatly
>> appreciated by myself and my patients
>>
>> Sincerely
>> Andrew N dela Torre MD
>> UMDNJ, University Hospital
>> Liver Transplantation
>> del...@um...
>>
>>
>> _______________________________________________
>> Pilot-db-list mailing list
>> Pil...@li...
>> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>>
>
> --
>
>

[pilot-db-list] Build of DB 1.0 for Handera

[Norman W. <nor...@ve...>]

Has someone out there built DB 1.0 in English for the
Handera with J-File and Mobile DB support? If so, will you
share it with me at:
nor...@ao...? 

Or, is there an FTP site where various builds are posted for
downloading?

Thanks for your help
Norm Wolfe

Re: [pilot-db-list] How do I set up a calculated field

[Scott W. <swa...@my...>]

> From: "Leiss, Klaus-Guenter 3188 S-PP-RD-E2"
> 	 <Kla...@de...>
> > I think this should be no problem for a large group of users. Almost
> > all calculator type applications that i know use MathLib.prc, you
> > could find an example with easycalc
> > http://sourceforge.net/projects/easycalc/
> > and GPLed calculator.
> 
> Would it be better to characterize the situation as being more along the lines
> of "DB scripting will remain with the current mathematical functionality
> until one of its users steps forward to write the code to do additional 
> functionality.  When the code is ready, the current maintainers should
> be contacted to see when they might have time to work over the changes
> and check them into the repository if the changes appear to be stable." ?
> 

I'm not personally opposed to adding support for MathLib calls to the 
scripting engine.  but you're right, its not at the top of my priority 
list.  If anyone wants to voluteer to get this done, that'd be great, but 
I think that db would profit from first getting 1.0.0 stable, then making 
sure the documentation is up to date, then making sure db-tools works, 
/then/ thinking about new features.

	(of course, I am always thinking about new features, because I am 
a feature-a-holic, so I am always open to talking about them, but I think 
that as a community, we need to think also about the making a stable, 
usable, application instead of one that has a bunch of half completed 
features....so I am trying my hardest not to extend db too much right now, 
however, in a month or so, I this may be a good possibility for an add on)

	-Scott

Re: [pilot-db-list] How do I set up a calculated field

[Larry W. V. <lv...@ca...>]

From: "Leiss, Klaus-Guenter 3188 S-PP-RD-E2"
	 <Kla...@de...>
> I think this should be no problem for a large group of users. Almost
> all calculator type applications that i know use MathLib.prc, you
> could find an example with easycalc
> http://sourceforge.net/projects/easycalc/
> and GPLed calculator.

Would it be better to characterize the situation as being more along the lines
of "DB scripting will remain with the current mathematical functionality
until one of its users steps forward to write the code to do additional 
functionality.  When the code is ready, the current maintainers should
be contacted to see when they might have time to work over the changes
and check them into the repository if the changes appear to be stable." ?
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden <mailto:lv...@ca...> <URL: http://www.purl.org/NET/lvirden/>
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
-><-

RE: [pilot-db-list] How do I set up a calculated field

[Leiss, Klaus-G. 3. S-PP-RD-E. <Kla...@de...>]

Hello Scott,

> 	Sadly, this is beyond the current abilities of db. 
> Including a function such as Log() would require installing 
> an additional 
> math library on most devices, and is not supported at this point.  If 
> there is enough support, we can consider adding support for 
> these complex 
> math operations.
> 
> 	-Scott

I think this should be no problem for a large group of users. Almost
all calculator type applications that i know use MathLib.prc, you
could find an example with easycalc
http://sourceforge.net/projects/easycalc/
and GPLed calculator.

With kind regards

Klaus Leiss
 

Re: [pilot-db-list] Feature Request

[marc-chalain <mar...@wa...>]

Our first target is to have a stable application, with PC tools and
documentations.

And will somebody be happy to write GREAT documentation of a GREAT
application??:)

Salut,
Marc.

Richard Schottler wrote:
> 
> Great program!  Would be even greater if the sort-order and filter in use
> on a view was saved and restored when re-activating a particular view.
> i.e., when selecting view "A", it would revert to it's previous filter and
> (multi-column) sort-order.  view "B" would revert to a different filter and
> sort-order.
> 
> If you really want to go hog-wild, allow filters and sort-orders to be
> named and saved with the database itself (filters already are saved, just
> not with a name), then associated with particular views as the default for
> those views.
> 
> I know I'm asking a lot, but these would really make a big difference in
> general usability.
> 
> Thanks!
> 
> =/\=  Rich
> sch...@us...
> 303.924.7016
> 
> "AAAAAAAAAAUUUUUUUUUUGGGGGGGGGGHHHHHHHHHH!!!!!!!!!!" -Charlie Brown
> ______________________________________________________________________
> 
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list

Re: [pilot-db-list] How do I set up a calculated field

[Larry W. V. <lv...@ca...>]

From: Scott Wallace <swa...@my...>

>Including a function such as Log() would require installing an additional 
>math library on most devices, and is not supported at this point.  If 
>there is enough support, we can consider adding support for these complex 
>math operations.


If someone else wants to look into adding this, there is a free math library
that is commonly included with PalmOS packages that would be worth
investigating . See
http://www.palmgear.com/software/showsoftware.cfm?sid=83587020020313063035&prodID=396
for the details - includes trig, log, exponentials, etc.

Since it is free, and so commonly available, it would not be hard to perhaps
create an extension or a plugin that made use of it.
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden <mailto:lv...@ca...> <URL: http://www.purl.org/NET/lvirden/>
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
-><-

Re: [pilot-db-list] How do I set up a calculated field

[Scott W. <swa...@my...>]

> I need to set up a calculated field using the addition of several log=20
> expressions to calculate a score(MELD)  assessing the severity of=20
> illness in patients with liver disease awaiting liver transplantation.
>=20
> The calculated field is as follows:
>=20
> ((0.957* Log(Case(Creatinine =E2=89=A5 4, 4, Dialysis  =3D "YES",4,Crea=
tinine))) +=20
> (1.12 * Log(INR)) + (0.378 * Log(Bilirubin)) + 0.643) * 10



	Sadly, this is beyond the current abilities of db.=20
Including a function such as Log() would require installing an additional=
=20
math library on most devices, and is not supported at this point.  If=20
there is enough support, we can consider adding support for these complex=
=20
math operations.

	-Scott



>=20
> Addtitional condition are
> 1. if creatinine > 4, max creatinine can only be 4
> 2. if patient was on dialysis within 2 weeks, creatinine will equal 4
> 3. if patient has a liver cancer and its size is less than 1 cm in=20
> diameter the total score is 24
> 4. if patient has a liver cancer and its size is greater than 1 cm the=20
> total score is 29
>=20
>=20
> Any help with information on script writing  in pilot-db will be greatl=
y=20
> appreciated by myself and my patients
>=20
> Sincerely
> Andrew N dela Torre MD
> UMDNJ, University Hospital
> Liver Transplantation
> del...@um...
>=20
>=20
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>=20

--=20

[pilot-db-list] display on visor screen

[Jean-Luc B. <Jea...@ac...>]

Hello
I'm trying P. d-b on a visor pro, my problem: if I activate the sort
options  (in global preferences), the filter menu comes 'above' the
direction arrows so that they become nearly unavailable especially the
down and right ones. how to change this?
thanks
-- 
Jean-Luc Blandin.

[pilot-db-list] How do I set up a calculated field

[Andrew de la T. <ade...@qw...>]

I need to set up a calculated field using the addition of several log=20
expressions to calculate a score(MELD)  assessing the severity of=20
illness in patients with liver disease awaiting liver transplantation.

The calculated field is as follows:

((0.957* Log(Case(Creatinine =E2=89=A5 4, 4, Dialysis  =3D =
"YES",4,Creatinine))) +=20
(1.12 * Log(INR)) + (0.378 * Log(Bilirubin)) + 0.643) * 10

Addtitional condition are
1. if creatinine > 4, max creatinine can only be 4
2. if patient was on dialysis within 2 weeks, creatinine will equal 4
3. if patient has a liver cancer and its size is less than 1 cm in=20
diameter the total score is 24
4. if patient has a liver cancer and its size is greater than 1 cm the=20=

total score is 29


Any help with information on script writing  in pilot-db will be greatly=20=

appreciated by myself and my patients

Sincerely
Andrew N dela Torre MD
UMDNJ, University Hospital
Liver Transplantation
del...@um...

[pilot-db-list] CF card

[<kp....@t-...>]

Hi,

I still can't put the db file onto the cf card. The database is always 
locked. I put db.prc and the db file into the palm/launcher directory. 
What do I do wrong? All os files seem to be current.
-- 
Herzlichen Gruss,

Klaus-Peter Kirlicks
--------------------
email: kp....@t-...
        kp....@t-...
        kla...@mu...

[pilot-db-list] Feature Request

[Richard S. <sch...@us...>]

Great program!  Would be even greater if the sort-order and filter in use
on a view was saved and restored when re-activating a particular view.
i.e., when selecting view "A", it would revert to it's previous filter and
(multi-column) sort-order.  view "B" would revert to a different filter and
sort-order.

If you really want to go hog-wild, allow filters and sort-orders to be
named and saved with the database itself (filters already are saved, just
not with a name), then associated with particular views as the default for
those views.

I know I'm asking a lot, but these would really make a big difference in
general usability.

Thanks!

=/\=  Rich
sch...@us...
303.924.7016

"AAAAAAAAAAUUUUUUUUUUGGGGGGGGGGHHHHHHHHHH!!!!!!!!!!" -Charlie Brown
______________________________________________________________________

Re: [pilot-db-list] Filter on Boolean Field - thinkDB

[Scott W. <swa...@my...>]

> How do I filter in a boolean field. I want to only show records where a
> field called "completed" is checked.

	I think that the string representation for a boolean 'true' field 
is '1', that's the way it looks in my copy of the source code.

	So try filtering on that criterion

> 
> Is there a plugin to allow viewing of thinkDB files?
> 

	No.


> Thanks in advance.
> 
> Melvin Mudgett-Price
> 
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

-- 

[pilot-db-list] Filter on Boolean Field - thinkDB

[Melvin Mudgett-P. <mp...@ac...>]

How do I filter in a boolean field. I want to only show records where a
field called "completed" is checked.

Is there a plugin to allow viewing of thinkDB files?

Thanks in advance.

Melvin Mudgett-Price

[pilot-db-list] palm-db-tools 0.3.3

[marc-chalain <mar...@wa...>]

I did a 0.3.3 release of Palm-db-tools but please be cool. I'm not the
maintainer of this project and i don't want to be. I give you my work
and nothing else. If you find some bugs send a bug resport on the
website, if i found that it's very important i will to correct it but i
will never add request feature. My work is only to add new field types
of Pilot-DB support. I added a little GUI which use the QT library. This
tool is not complete.
I will build a 1.0.0 soon but after i stop the developpement of this
tools.

Salut,
Marc.

RE: FW: [pilot-db-list] (no subject)

[KANE P. (CA) <Pet...@er...>]

I think I'd prefer DBpl

-----Original Message-----
From: Scott Wallace [mailto:swa...@my...]
Sent: Thursday, 14 March 2002 23:27
To: marc-chalain
Cc: pilot-DB
Subject: Re: FW: [pilot-db-list] (no subject)


On Thu, 14 Mar 2002, marc-chalain wrote:

> true, in fact the plugins and the main application have the same
> CreatorID and PalmOS doesn't know what name to display.
> 
> If i must change that i must ask a new CreatorID to Palm Inc and i don't
> know when i will have the result.
> 
> What do you prefer?
> Salut,
> Marc.

I think we should have a creator id that is the same for all plugins, but 
different than the db creator id.

	DBPL, DBpl, DBPG, and DBpg are all still available.  If you want, 
I will register one of these.

	-Scott





This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062 
Ergon Energy Pty Ltd      ABN 66 078 875 902

[pilot-db-list] palm-db-tools

[marc-chalain <mar...@wa...>]

we will have a palm-db-tools v1.0.0 thank to Fab.
Now i need to complete the calculated field support with Scott.
Salut,
Marc.

Re: FW: [pilot-db-list] (no subject)

[Scott W. <swa...@my...>]

On Thu, 14 Mar 2002, marc-chalain wrote:

> true, in fact the plugins and the main application have the same
> CreatorID and PalmOS doesn't know what name to display.
> 
> If i must change that i must ask a new CreatorID to Palm Inc and i don't
> know when i will have the result.
> 
> What do you prefer?
> Salut,
> Marc.

I think we should have a creator id that is the same for all plugins, but 
different than the db creator id.

	DBPL, DBpl, DBPG, and DBpg are all still available.  If you want, 
I will register one of these.

	-Scott