Re: [pilot-db-list] =?iso-8859-1?Q?Fw:Thank_you...?=

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

> Helme, Nancy E. wrote:
>  
> The database worked great until I added the link and linked
> fields.  Now the 
>  
> (* (* denomination rebatepercent) quantity) 
>  
> script says its incompatible and must be fixed.  I cannot have
> any linked field in a calculation or it errors (invalid
> arguments for *).  As soon as I change the linked fields to
> either constants or another numeric field, it works fine.

	Yes, Link and Linked fields end up represented as strings in the 
destination database as opposed to their real types.  This means that as 
far as the scripts are concerned, you're now trying to multiply two strings 
together.   If they're integers, then you can tell the script to treat the 
strings as such by casting them with the 'int' function:

	(* (int <linked field>) (int <other linked field>))

but if they're floats there is no current way to do this.  However, I've 
been putting together some changes for a 1.1.3 release.  I will add a 
similar function to cast strings to floats.

>  
> Can you help?
>  
> (And is there a support fund I can contribute to??  It's so
> nice to be able to introduce people to databases and palms
> without making them shell out $40.  My friend had to scrape
> together the money for the palm itself.)
> 

	Actually, there's no real way to formally donate.  Although, if 
you really think db is great, then some volunteer time is always greatly 
appreciated.

	-Scott