Before I offer my $0.02, Alastair, may I ask you if these are indeed single characters w/in the paren's? Might they be INTEGERS? Although I often store the data as TEXT, I "CAST" it to INT w/INT(.vCharacter), at least if it's numeric. Otherwise, I'd use CHAR(.vCharacter) to get its ASCII value and use that.
I'm asking you this before I offer my assistance as your answer to this will help guide my answer to your original Q. Thanks, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Alastair Burr > Sent: Monday, July 01, 2002 12:09 PM > To: R:Base ListServer > Subject: Forms: Pop-Up menu - Where clause variable > > > 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/ > ================================================ 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/
