Do you need to put ' ' around the text values?
Vlist = ('part1','part2','part3')
or
Select all from .... Where partnumber in &Vlist
Marc
From: Dan Goldberg
Sent: Friday, May 27, 2011 8: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
