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
--
32 years of continuous innovation!
17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
