RE: qry manager queries and character replacement variables

Richard,

You've got the idea.  For some reason I can't remember right now (coz its
friday and I'm a lazy guy), QM parms are wierd.  I think the image you are
supposed to pass in is:

''STUFF''
123456789

which becomes 

'STUFF'
1234567 

in the SQL statement.  Of course, I usually get this stuff wrong the first
two or three times, but.......  I'm sure sombody out there will straighten
this out if'n I'm wrong. :) I think there's a FAQ about this.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Richard B Baird [mailto:rbaird@esourceconsulting.com]
Sent: Friday, January 17, 2003 12:24 PM
To: Midrange Systems Technical Discussion
Subject: RE: qry manager queries and character replacement variables



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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.