You can try
SET VAR vyourvar = ('('+.vyourvar+')')
INSERT INTO yourtemptable (yourcolumns) SELECT columnsyouwant FROM
originaltable WHERE yourPK IN &vyourvar
-----Original Message-----
From: Patti Jakusz <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Tue, 14 Jun 2011 10:40:28 -0700 (PDT)
Subject: [RBASE-L] - Multicolumn Select in Var Lookup ListView
Hi,
I want to have a form in which a user can select a bunch of records, then I
do some other processing with these records. I'm using 7.6.
So I put a Variable Lookup ListView Box on my form, and selected the option
for Multicolumn select. When I show variables, Rbase has put the keys to
all the selected records into my one variable, separated by commas, just
like I had hoped.
But now I don't know how to use them. I'd maybe like to dump them in a
temporary table, but I don't know what kind of syntax to use to get at all
these different values for my variable.
Any help?
Thanks,
Patti Jakusz
