Hi All,

Again, I need a little help. 

The following PROCEDURE LINE works just fine.  In this case I'm just 
inserting the variable V.CALENDAR.YEAR to complete my file suite and I am 
going after 2  alphanumeric records ('P2021422' 'P2083158').

PROCEDURE LINE "SELECT GLA.":V.CALENDAR.YEAR:" WITH GLA.REF.NO = 
'P2021422' 'P2083158'"

The problem arises when I attempt to select from a LIST (below)

PROCEDURE LINE "SELECT GLA.":V.CALENDAR.YEAR:" WITH GLA.REF.NO = ":
VL.JS.LIST.VAR1

Of course the system does not like the Value Marker so I need to get rid 
of it...

VL.JS.LIST.VAR1 = "'":CONVERT (@VM,"' '",VL.JS.LIST.VAR1):"'"

The hope here is to replace @VM with ' ' and then place the ' at each 
end... but CONVERT will only switch one for one - one @VM for a single 
single quote (') which results in a quote mismatch.

Any suggestions?

Greg
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to