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

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

Dear Scott,

you wrote:

>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 enter a dialog in which nothing can be entered!
No text, no script!
Could that be due to the specific problems
of the Palm OS 3.3 or due to the Palm Pilot Professional 1000
hardware with 2 MB upgrade kit?

Could you test it with Palm OS 3.3

Hans

-----Ursprüngliche Nachricht-----
Von: pil...@li...
[mailto:pil...@li...]Im Auftrag von Scott
Wallace
Gesendet: Dienstag, 23. Oktober 2001 22:01
An: pil...@li...
Cc: aji...@t-...
Betreff: [pilot-db-list] Re: Bug Report -- Calculated Field


>
> 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


_______________________________________________
Pilot-db-list mailing list
Pil...@li...
https://lists.sourceforge.net/lists/listinfo/pilot-db-list