If your field has a finite valid range (i.e. 0 to 99,999) than use a value outside that range to denote no entry. Of course that depends on what your UInt16 is representing. If its a generic data, you may have to alter your data structure.
----- Original Message ----- From: "Jay Francis" <[EMAIL 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 thing. When > you query with statement such as IsNull then you are > searching for this special flag (no data entered). > Just don't know how the big programs know the > difference then between the flag and an entered value. > User could enter a zero or leave it blank which would > then be coded as a zero. If I coded it as a Int16 then > I could save the no-entry value as a negative value > (which user cannot enter through my keypad) but hate to > change a datatype based on this. Am I in the > ballpark on this concept? Jay > > > > -- > For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/ > -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
