Re: [pilot-db-list] Script in calculated field... what am I missing?

[Yedidyah Bar-D. <di...@ta...>]

On Mon, May 03, 2004 at 01:29:43PM -0600, Nelson E. Ingersoll wrote:
> 
>    I am learning Pilot-DB, so please be patient with me.   I am using 
> DB on my new Tungsten|E.  The database and program all reside in the 
> main memory.
> 
>    As a test I have made two databases.  One is a copy of my CD 
> database from CATraxx.  It has 340 records and the import, using DB-Edit 
> worked GREAT!   The second is a more interactive database... 
> specifically a fuel log database where I enter appropriate information 
> such as cost of fuel, amount of fuel, total price, and trip distance 
> since last fill-up, followed by MPG (calculated Miles Per Gallon).
> 
>    In this simple example cost, quantity, and total price are floats, 
> trip distance is an integer and MPG is calculated by dividing trip 
> distance by quantity of fuel.   In the script section I entered when 
> declaring the calculated field I put "/ %5 %3 ".  The field numbers are 
> those I see in the database design screen.

You should put parens around, e.g. "(/ %5 %3)". That's LISP.
-- 
Didi

> 
>    I get an error "?Who knows?" (after entry) or "[broken]" (after a 
> rebuild or recalculate).  I've been reading the documents trying to 
> figure out my mistake but have failed so far.  Any thoughts?
> 
> Nelson E. Ingersoll
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 
> +++++++++++++++++++++++++++++++++++++++++++
> This Mail Was Scanned By Mail-seCure System
> at the Tel-Aviv University CC.