Re: [pilot-db-list] Thank You and Feature Request

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

On Mon, 25 Nov 2002, mowestusa wrote:
> 
> I found out that you must not be able to mix the field
> types when using a calculated field.  I had a integer
> field and a float field that I was carrying
> calculations on at the same time.  I switched
> everything to integer and it worked great.

Hmm.  This should actually work. That is, you should be able to do:

Field 0 = Integer
Field 1 = Float

Field 2 = Calculated '(+ %0 %1)'

without any trouble.  However, if you change the field types after you 
have defined the script, then you may need to refresh the scripts (i.e. 
retype them in).  This could cause a problem if you had a script as above 
but both fields were initially integers, and then you changed one to a 
float without updating the script.  However, if you were to go the other 
way (one field is a float, that then changes to an integer) you shouldn't 
have to refresh the script (in theory).

	-Scott

I think I should add something to the documentation about this ;)

The basic rule is that if you change the database design (i.e. the field 
types or their relative order, etc) you should always re-enter your 
scripts to make sure that they are appropriate for the new database 
design.