Thanks, Thomas & Javier, but it seems to make no difference if the list of
letters in variable is in quotes or not - but only as long as there are no
spaces in each item. So (A,B,C) works but (Joe Bloggs, Fred Bloggs, Mike
Bloggs) would fail without quotes.
I'm not sure which way is correct so, generally, I use the quoted version to
be safe. However, for this problem, that is not the cause as far as I can
tell.
Thanks & regards,
Alastair.
----- Original Message -----
From: "Thomas J Cimicato" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 10:13 PM
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/
