On mar, 2007-10-16 at 12:58 +0200, Murray Cumming wrote:
On Tue, 2007-10-16 at 12:36 +0200, Federico Munerotto wrote:On mar, 2007-10-16 at 08:46 +0200, Murray Cumming wrote:On Sat, 2007-10-13 at 19:59 +0200, Federico Munerotto wrote:How can I say a field to be filled with return record.related["marche"]["nome"] ? As developer, in layout, I've been able just to add a button andnotsuch field.You can define a calculation for a field and then add that fieldto thelayout.You meant: SELECT *, description as description2 FROM mytable where MYCOND and add in layout .description2 ?No, you don't need to write any SQL. Just create a new field. Then edit that field. Then go to the Value tab. Then specify a calculation, such as "record.related["marche"]["nome"]" Close the Field Definitions window and put the new field on the layout. The "small business" example does this for the name_full field.
I did
but
I created the field desc2
Nothing seemed to be happened so I reopened the form for the field
calculation and pressed the "test" button, I got as reply "The result of
the calculation is: NULL".
I think to have done all in a correct way: can you figure out what may
be?
Thanks, and sorry for the bothering.
--
Fede
________________________________________________________________________
mune (at) fsfe.org Ing. Federico Munerotto
home http://www.mune-web.eu
Public key http://www.mune-web.eu/personal/misc/pk/pk.html
Signoraggio http://www.mune-web.eu/personal/misc/signoraggio/
________________________________________________________________________
posta firmata digitalmente | mail digitally signed
______________________________________|_________________________________
You are number 6! Who is number one?
Attachment:
signature.asc
Description: This is a digitally signed message part