NULL data question

I have several numeric fields in a record. Some are required, some are not. If an unrequired field is left blank, shouldn't I write to the field as NULL? When I do, and then get the value from the databases after the save, the structure member indicates that the value is 0. I can always

Re: NULL data question

: Wednesday, May 15, 2002 9:58 AM Subject: NULL data question I have several numeric fields in a record. Some are required, some are not. If an unrequired field is left blank, shouldn't I write to the field as NULL? When I do, and then get the value from the databases after the save

Null data question

Thanks Dave, The data type is UInt16. Sounds like I'll need to save a value that is a flag for no-entry. I'm guessing then that the big database programs do the same thing. When you query with statement such as IsNull then you are searching for this special flag (no data entered). Just don't

Re: Null data question

PROTECTED] To: Palm Developer Forum [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 11:34 AM Subject: Null data question Thanks Dave, The data type is UInt16. Sounds like I'll need to save a value that is a flag for no-entry. I'm guessing then that the big database programs do the same