Dan
You will have to use the ampersand (&) instead of the period
SET VAR vlist = ( '(' + .vlist + ')')
select all from partslist where partnumber in &vlist
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Dan
Goldberg
Sent: Friday, May 27, 2011 9:47 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Using values from choose to select
I have a choose command that uses the chkbox to select multiple part
numbers and stores it in a variable.
vlist = part1,part2,part3
I want to do a select command displaying the selected parts.
I tried this:
select all from partslist where partnumber in (.vlist)
I know I have done this before but is drawing a blank.
TIA
Dan Goldberg
