Cheryl
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')
Buddy
-----Original Message-----
From: McClure, Cheryl [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 10:26 AM
To: Rbase-L (E-mail)
Subject: Using multiple results of Choose w/ CHKBOX
I want to print a report for multiple transactions in a credit card
database. I have selected the identifying codes of those transactions
using:
CHOOSE vlist FROM #VALUES FOR DISTINCT trans FROM ccTABLE
My variable vLIST is now equal to a list of codes separated by commas. I
can put parentheses around these values using:
Set VAR vResult =('('+(.vLIST)+')')
If the values are INTEGERS, I can easily print my report where transaction
is IN that dataset:
PRINT ccREPORT WHERE trans IN &vresult
However, if the column TRANS is a text field, I don't see how I can put
quotes around each value to make this same scenario work. Solutions?
Thanks!
Cheryl
================================================
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/
