Yes, it works great (with the parenthesis). I just learned the &var thing last week. My focus got shifted and I couldn't use it yet, and now here it is as the answer to my problems - again. Thanks everyone for your help. 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:56 PM I believe the use of the IN needs to be enclosed in (). Im not using a full keyboard so typing is a challenge -----Original Message----- From: Patti Jakusz <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 14 Jun 2011 11:52:08 -0700 (PDT) Subject: [RBASE-L] - Re: Multicolumn Select in Var Lookup ListView 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
