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
Thanks anyone.
Lucas Edwards
Information Systems
Wesley Mission Brisbane
