I sent this to myself last night I was that excited!!! Regards, alastair
----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "Alastair Burr" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 12:17 AM Subject: Re: Forms: Pop-Up menu - Where clause variable Yes! Project the temp table in an EEP on entry into the field with the selected data and pre-sorted... Set the field pop-up to the temp table (created first, of course) - no where clause, no sort... Run the form... Perfect - and very quick! (Drop the table at the beginning of the EEP so that it can be re-created each time the field is entered.) Thanks Ben for the idea, Regards, Alastair. ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 11:50 PM Subject: Re: Forms: Pop-Up menu - Where clause variable > > Thanks Ben, if all else fails your idea should work - I could create the > > temp table in the EEP and then use that in the pop-up from the field. > > > > I wonder if I can create the temp table on entry into the field with an > EEP > > and then get the menu to pop-up from it. That way the table would only get > > created if needed. Think I'll try that anyhow, it might be useful in all > > sorts of places if it works... > > > > Thanks & regards, > > Alastair. > > > > > > ----- Original Message ----- > > From: "Ben Petersen" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, July 01, 2002 2:38 PM > > Subject: Re: Forms: Pop-Up menu - Where clause variable > > > > > > > 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/ > > > ================================================ 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/
