Just a quick correction, for double quotes use CHAR(34) rather that CHAR(32)
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas J Cimicato Sent: Monday, July 01, 2002 4:13 PM To: [EMAIL PROTECTED] Subject: Re: Forms: Pop-Up menu - Where clause variable This is what I use to create the where clause for the choose. [Note: The (CHAR(39)) is the single quotes. Use (CHAR(32)) for double quotes] SET VAR vWhere = (' LastName = ' + (CHAR(39)) + .vdlname + (CHAR(39)) ) Then use &vWhere as the entire where clause ex. Choose ...... where &vWhere it will resolve to where vdlname = 'smith' You can make the vWhere clause as sophisticated as you like just be sure to enclose text variables with the CHAR value of your quote setting. Works like a charm. I used it in 4.5++ initially and converted nicely to 6.5++ today. I don't often have much to contribute on the list but I just so happen to have been working on this exact program today and still had it in my editor to refer to. Enjoy! At 06:08 PM 07/01/2002 +0100, you 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/ Thomas J Cimicato President Integrated Check Technologies Collect-A-Check, Inc. ------------------------------------------------------------ Bus:800.338.0676 x3120 614-55-CHECK Fax:614-552-4439 Mailto:[EMAIL PROTECTED] www.ICheckTech.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/ ================================================ 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/
