RE: qry manager queries and character replacement variables

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Eric,

do you have this backwards?  i.e. you don't put the quotes and +'s in the
sql statement, but you build the variable in the CL like this:

DCL &orgout *char (8)

chgvar &orgout ('"' *TCAT &ORGIN *TCAT '"')     ?

so that the value of the &orgout is    "CSR301"
                                       12345678

?

I tried that with single quotes, but it didn't work.  i'll try with doubles
next.

thanks,

Rick
----original message-----
Richard,

More fun with "'"'s :)  Remember, you gotta build an extra layer of
apostrophe's before you pass it in.....

ORIGORG   = '"' + &A5 +'"'

Eric DeLong