Hi Jan,
This looks good too but I'm not sure where I would put the statement
SET VAR vyourvar = ('('+.vyourvar+')')
or even if I'd really need it. I think it's already done by the multiselect.
Already. my vyourvar = PK1, PK2, PK3, PK4 . Wouldn't the 2nd statement work
too, since I don't have commas in my primary keys. Or maybe I'm not
understanding what the first statement is for.
Patti
--- On Tue, 6/14/11, jan johansen <[email protected]> wrote:
From: jan johansen <[email protected]>
Subject: [RBASE-L] - Re: Multicolumn Select in Var Lookup ListView
To: "RBASE-L Mailing List" <[email protected]>
Date: Tuesday, June 14, 2011, 6:32 PM
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
