Dan: Have you tried it using an ampersand variable instead of a dotted variable? i.e. select all from partslist where partnumber in (&vlist)
Hope that helps. Mike Ramsour From: "Dan Goldberg" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: 05/27/2011 09:48 AM Subject: [RBASE-L] - Using values from choose to select Sent by: [email protected] 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 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
