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
