If you are running the current R:Base versions, I would recommend not returning the
text values, but return the id column. A fairly recent enhancement allows a checkbox
menu to return the integer PK while displaying the text you choose. This would obviate
the parsing problems with the list.
CHOOSE vList FROM #VALUES FOR CompanyName,CompID +
FROM Customers +
ORDER BY CompanyName +
AT CENTER CENTER CHKBOX FOOTING
SET VAR vList = ('(' + .vList + ')')
R>SHO VAR vList
R>(123,334,12,254,77,898,237,105)
This makes for a shorter list, allowing more choices (1500 character text variable
length limit allows quite a few integers), and there is no need to quote the inner
items, which in turn eats up more of the 1500 available characters.
"Lawrence Lustig" <[EMAIL PROTECTED]> wrote:
>> � You won't need the quotes if the text values do not have spaces...
>> � Quotes not necessary
>> � �IN (ME,YOU,THEM,ANDUS)
>> � Quotes would be needed
>> � � IN ('ME,'YOU','THEM,'AND US')
>
>While it is try that R:Base is pretty relaxed about using quotes in lists in
>this particular situation, I would strongly recommend coding with the
>quotes. �In each successive version R:Base has gotten stricter about
>adherence to the things like this, and at some point you will need to use
>the quotes.
>
>If you code without the quotes you will have a program that is correct
>because "my data doesn't have space, commas, hyphens, etc in it". �If you
>code with the quotes your program will be guaranteed correct by design.
>--
>Larry
>
>
>================================================
>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/
>
--
Albert Berry
Full Time Consultant to
PSD Solutions
350 West Hubbard, Suite 210
Chicago, IL 60610
312-828-9253 Ext. 32
__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/browsers/download.jsp
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
