[pilot-db-list] Re: Bug Report -- Calculated Field

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

>
> I just tested the last alpha release.
> I use a PalmPilot Professional 1000
> with a 2 MB Upgrade kit,
> OS 3.3
>
> 2)
> create database called 'bbb'
> create two float fields 'fl1' and fl2'
> If I create a calculated field, I enter a
> menu field in which I cannot select anything
> and cannot enter anything.
> If I exit I get a dialog called 'Debug'
> with the error message:
>
>    unexpected end of script
>
> Can anyone tell me how to use the calculated
> field?

Hmm,

	I just tried this (using db-3.3 alpha).  Once I set the third
field to calculated, I enter a dialog called 'fld 3'.  There is a field
(without a label) in which text can be entered.  I write the script:

	(+ %0 %1)
and hit 'done'.  This seems to work just fine.


Here is how to use scripts:

	each script is a lisp-like clause

		 (<operator> <arg1> ... <argn>)

	arguments are either constants (e.g. numbers) or references to
fields.  Fields are referenced using a '%' character & their location.  So
%0 refers to the 1st field, %1 to the second and so on.

	some of the valid operators are:  +,-,*

	so here are some script examples:

	(+ %0 %1) 		add 1st two fields
	(+ %0 4)                add 4 to the value of the first field

	a complex one is:

	(+ 4 (* 3 %1))         add 4 to 3 times the value of the 1st field


I will document all of this more completely in the next few days.

	-Scott