how tto indicate null values in a script?

[rlbryant]

Hello,

How do I represent a null value in a script (e.g., null date, empty string, null time).

Thank you,

rlbryant

[Søren Dyhr]

I havn't investigated if this typecast still works under 7.0 - but with previous versions did it miraculous work regardless of field type:

Go to Field [

[transpower]

=""

[Søren Dyhr]

No Transpower you get a validation message if trying so with a time or date field. Obviously can Clear do the same thing for things in the taborder. But I would like to experiment with voiding a random field being show or not on a layout ...but GetField( might prove promissing!

--sd

[Ender]

It's not clear what rlbryant is looking for here, but to test for a null value, Isempty(field) is best.

[Søren Dyhr]

I took it for granted that rlbryant wouldn't dare to xpost

[rlbryant]

Thank you to everyone who responded. I'd like to do a number of things with various data types (date, number and text) -- for example (1) build a case statement that says if such-and-such field has no value (null) fill it with this value, otherwise leave it as is; or (2) if the field Last_Payment_Date has a value, fill Next_Payment_Date with <calculated value here>; otherwise leave it blank (null). Those are just two examples. I'm having trouble basically understanding how Filemaker references and recognizes null values (of all data types). I have the books "Filemaker Pro Bible" and "Filemaker Pro for Windows and Macintosh" but I'm not finding either of them to be especially helpful. This forum is MUCH more helpful but I'm sure it's a nuisance to have someone constantly asking such rudimentary questions. Can anyone recommend a good Filemaker manual?

Thank you VERY much to everyone for all of your help!

rlbryant

It's not clear what rlbryant is looking for here, but to test for a null value, Isempty(field) is best.