Dick Did you try using the & in front of the end variable. Assuming your end variable name is vDoEdit
&vDoEdit Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Carpet Broker, Dick Fey Sent: Tuesday, March 31, 2015 3:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Building Query in a form Razzak... I didn't ask enough questions. Your code works perfectly, now have my query, but how do I trigger it to work? At the end I have a variable that says 'EDIT all from Venprice where etc etc etc.' but I can't make it do the edit. R:thanks, Dick Fey On 3/31/2015 1:35 PM, A. Razzak Memon wrote: > At 12:43 PM 3/31/2015, Carpet Broker, Dick Fey wrote: > >> Sometimes you work on something so long your brain goes numb. >> >> I want to build a query, user enters a vendor code, and the query >> gets built. >> >> Form: Enter PayCode users enters PH >> >> Resulting query needs to read; where paycode = 'PH' >> >> Cannot figure out how to get the query to pick up the PH with quotes. >> >> have tried .variables, &variables, cannot get it to work. >> >> The whole query is much more complex, but once I get the code to work >> for 1 field, I am set. >> >> Probably a 'duh' but I would welcome suggestions > > > Here's how: > > Assuming that you are collecting the user input in a variable, such as > vKeyword TEXT. > > Use the following Code as On Exit EEP: > > SET VAR vQuotes TEXT = (CVAL('QUOTES')) SET VAR vString TEXT = NULL > SET VAR vString = ('WHERE PayCode ='&.vQuotes+,.vKeyword+.vQuotes) > > The resulting vString will look like this. > > WHERE PayCode = 'PH' > > Once you understand this approach, use the code as you see fit. > > Very Best R:egards, > > Razzak. > > www.rbase.com > www.facebook.com/rbase
