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/
