[RBASE-L] - RE: Using values from choose to select

[Dan Goldberg]

That works!

Thanks

Dan
  From: Walker, Buddy 
  Sent: Friday, May 27, 2011 6:52 AM
  To: RBASE-L Mailing List 
  Subject: [RBASE-L] - RE: Using values from choose to select


  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: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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