Lucas,
CHOOSE varname value is ALWAYS returned as TEXT.
01. Always SET varname to TEXT = NULL before using
the CHOOSE command.
02. SET that variable to INTEGER after the CHOOSE
command, for example:
SET VAR varname INTEGER
or
Create another INTEGER variable to hold that
value, for example:
SET VAR varnameInt INTEGER = .varname
Have Fun!
Very Best Regards,
Razzak.
At 01:36 PM 4/29/02 +1000, Lucas Edwards wrote:
>CHOOSE syntax
>Please someone correct me here.
>I'm assuming the syntax for CHOOSE is as follows:
>CHOOSE varname FROM #VALUES FOR (expression),retcol +
>FROM tblname WHERE clause AT scrnrow scrncol +
>TITLE 'title' CAPTION 'text' LINES n FORMATTED
>Where retcol is the value returned to varname +
>and can be an integer, text, whatever.
>If this is the case can anyone please explain to me +
>why the following code returns a text value?
>CHOOSE vresident FROM #VALUES FOR +
>((LJS((CTXT(IDNO)),6)) & LASTNAME & FIRSTNAME),IDNO +
>FROM CLIENT WHERE LASTNAME LIKE .vsearch AND +
>STATUS NOT IN ('OWL') +
>AND COURID LIKE .vuser ORDER BY LASTNAME AT 8,25 +
>TITLE 'Choose Residents' +
>CAPTION 'Resident' LINES 20 FORMATTED
>Where CLIENT.IDNO is a unique integer.
>After the CHOOSE, +
>vresident = ((LJS((CTXT(IDNO)),6)) & LASTNAME & FIRSTNAME)
>In fact, if I declare vresident INTEGER = NULL then Rbase +
>returns an error.
>????????????????
>I'm using 6.5++ 1.851xRT03
================================================
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/
