Son of a Gun!
Thanks Dr R>
Ben Petersen
On 12 Jun 2002, at 18:16, A. Razzak Memon wrote:
>
> 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/
>
================================================
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/
