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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users