At 02:02 PM 6/12/2002 +0100, Ben Petersen wrote:
> > SET VAR vm_keepnull = (CVAL('NULL'))
>
>This doesn't work... as an example, if null is set to -0- when this var
>is set, and null is then set to ' ', vm_keepnull will also be set to a
>space... the null value is stored, not it representative characters..
>so you can't retrieve the original -0-. It's not used anywhere in the
>routine, but might leave a person wondering.
SET VAR vNull TEXT = 'NULL'
SET VAR vm_KeepNull = (CVAL(.vNull))
The variable vm_KeepNull will return the database NULL setting!
The same trick can be applied for other CHARacter settings.
Have Fun!
Very Best Regards,
Razzak.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
