Bernie, All the better. Maybe this is an improvement in more recent versions. I know I was denied creating a view w/in an eep recently under an older version (6.1a or 6.5+). And seemed to remember (silly me, remember <g>) a restriction on structure changes w/in eeps.
Ben Petersen On 1 Jul 2002, at 23:39, Bernie Corrigan wrote: > Ben - > > I just tested that theory and you can create either regular or TEMP > tables from within an EEP. This in version 1.851. I did not test to see if > you could create one in an entry EEP and then use it in a popup for the same > field. > > Bernie > -------------------------------------- > At 05:15 PM 7/1/2002 +0100, you wrote: > >Alastair, > > > >You're not allowed to make structure changes within eeps... so you > >would have to create the temp table in advance of using the form. > >Even if created w/out being needed there is no harm (like datafile > >bloat). You could then control the content of the table from the eep. > >And temp tables are fassstttt! > > > >Ben Petersen > > > > > >On 1 Jul 2002, at 23:50, Alastair Burr wrote: > > > >> 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/ > >> > > > > > >================================================ > >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/
