try (in 6.5++) the syntax CHOOSE ... FROM ... #LIST .vLookup ... .vLookup is a comma delimited text string.
To test it I did SET VAR vLookup TEXT = '1,2,3' CHOOSE vTest FROM #LIST .vLookup in RBWin 6.5++ 1.851xRT03 "Alastair Burr" <[EMAIL PROTECTED]> wrote: >Hi everyone, > >I'm trying to get a pop-up menu to work in a form using this syntax in the >"where clause" box: > >WHERE Name_Type IN (.vLookUp) ORDER BY Full_Name > >The value of vLookUp is defined as text and has a value of: "(A,B,C)" - the >bit between the double quotes. > >I've tried a number of variations such as "&vLookUp" both with and without >the brackets. >I've also tried putting the IN in the variable: "IN (A,B,C)" and removing it >from the where clause. > >Nothing I've tried seems to work. Is there some limitation on variables in >the where clause here? R:Base gives me various error messages depending on >the syntax but the real problem seems to be that it can't evaluate the >variable. > >Thanks in advance for any help or suggestions, >Regards, >Alastair. > > >---------------------------------- >A D B Burr, >St. Albans, UK. >---------------------------------- >[EMAIL PROTECTED] >---------------------------------- > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
