On 08/06/11 16:47, Greg Coelho wrote:
> 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?
>
Yes. I think you need the ?REPLACE? function. There is a function that
replaces one string with another. It might be EREPLACE instead.
Anyways. Read the BASIC manual - it is there.
Cheers,
Wol
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
