Re: [pilot-db-list] calculations with linked fields as arguments?

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

On Fri, 25 Apr 2003, julio sameiro wrote:

> Hi!
> 
> in a dbase, db2, like this:
> 
> field0: link to a key on db1
> field1: linked (it shows the result of a calculated field on db1)
> field2: (+ %1 5) <-- when i try something like this an error msg occurs 
> - "bad argument for +"



	Yes, in general, this won't work.  If the linked field is an 
integer, then you might be able to do something like:

	(+ (int %1) 5)

	the problem is that linked fields are viewed as strings, not their 
original data type, so you need to somehow convert them back to their 
original type.  I'd like to fix this problem at its root, but it would 
require a new database format, and it would be pretty hard to make it 
robust.

	-Scott