Alastair,
I have a routine which does something similar...
The user chooses one or more equipment numbers from a pop-up list and
"eqnbr" looks like: Number1,Number2,Number3,etc.
The code is:
CHOOSE eqnbr FROM #VALUES FOR (LJS(eq_nbr + ",",11) & eq_des), eq_nbr FROM +
equip WHERE (eq_des CONTAINS .veqdes OR eq_nbr CONTAINS .veqdes) AND +
eq_nbr IN (SELECT eq_nbr FROM xref) ORDER BY +
eq_nbr AT 1 CEN CHKBOX CAPTION "Choose Equipment Number(s)" LINE 20 FORM
Then, I have:
SET V xeqnbr =("EQ_NBR IN" & "(" + .eqnbr + ")")
PRINT xref WHERE eq_nbr IN (SELECT eq_nbr FROM xref WHERE &xeqnbr) +
ORDER BY eq_nbr pr_nbr
It works well.
Dennis
*****
At 06:08 PM 7/1/02 +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/
>
>
Dennis Fleming
IISCO
http://www.TheBestCMMS.com
Phone: 570 775-7593
Fax: 570 775-9797
================================================
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/
