Cheryl,
Try
Set v vList = (''''+srpl(.vList,',',''',''')+'''')
The above are all single quotes. 4 for the outer parens, 3 for the
inner parens. To treat a quote like a regular text character you use
2.
Ben Petersen
On 20 Nov 2002, at 10:26, McClure, Cheryl wrote:
> 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/
