Alastair,
Form a past experience I don't believe you can do it just as you
have it. But in reading this post it occurred to me that maybe you
could do it by having your pop-up refer to a temp table or view that
could construct just before using the form...
Create temp view YourView (PopVals) +
as sel 'A' from dummy whe limit = 1 union +
sel 'B' from dummy whe limit = 1 union +
sel 'C' from dummy whe limit = 1
then:
WHERE Name_Type IN (sel popVal from yourView) ORDER BY
Full_Name
and if you needed it to be more dynamic:
Set v a = 'A', b='B',c='C'
Create temp view YourView (PopVals) +
as sel (.a) from dummy whe limit = 1 union +
sel (.b) from dummy whe limit = 1 union +
sel (.c) from dummy whe limit = 1
a,b and c can then show in the popup as whatever values you set
the vars to.
Ben Petersen
On 1 Jul 2002, at 21:50, Alastair Burr wrote:
> Thanks, Mike, but that doesn't solve it. I get a "No rows exist or satisfy
> the specified clause" message but the choose works at the R:> as expected
> (with or without the extra quotes).
>
> It is as if the form pop-up menu box can only accept column names or text
> and cannot evaluate a dotted or ampersand variable:
>
> WHERE Name_Type IN (A,B,C) ORDER BY Full_Name works but
> WHERE Name_Type IN (.vLookUp) ORDER BY Full_Name does not work - with
> whatever variations that I've tried for the variable.
>
> Albert, I can't figure out how to get your example into the where clause in
> the box on the form but thanks anyway. Again, I think that this particular
> box just cannot evaluate a variable...
>
> Dennis, your idea would work for me if I used an EEP to pop-up the choices
> but I would still be stuck getting the variable into the where clause box on
> the pop-up menu box for the field on the form.
>
> It looks as if I'll have to pop the menu up from the EEP which is easy
> enough but, in this case, means quite a big change to the form which I was
> trying to avoid. It's the change that probably breaks the camel's back and
> means I really ought to re-construct the form from first principles to
> consolidate various changes and I was just feeling put off by the thought of
> the work involved.
>
> Thanks, everyone,
> Regards,
> Alastair.
>
>
> ----- Original Message -----
> From: "MikeB" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, July 01, 2002 7:31 PM
> Subject: Re: Forms: Pop-Up menu - Where clause variable
>
>
> > How about single quotes surrounding each of the IN LIST parts?
> >
> > ----- Original Message -----
> > From: "Alastair Burr" <[EMAIL PROTECTED]>
> > To: "R:Base ListServer" <[EMAIL PROTECTED]>
> > Sent: Monday, July 01, 2002 12:08 PM
> > 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/
>
> ================================================
> 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/
