RE: Concatenation Operator in 4GL
Hi,
The "PREPARE" and "EXECUTE" worked.
Thanks for all the answers.
Wendy
> -----Original Message-----
> From: Rekaish Bhardwaj [SMTP:RekaishB@compans.com]
> Sent: Wednesday, October 13, 1999 11:23 AM
> To: 'Wendy Zheng'; informix-list@iiug.org
> Subject: RE: Concatenation Operator in 4GL
>
> yes,
> In your 4gl try preparing the sql and then execute it
>
> cheers
> Rekaish
>
> -----Original Message-----
> From: Wendy Zheng [mailto:hzheng@ebi.com]
> Sent: Wednesday, October 13, 1999 3:00 PM
> To: informix-list@iiug.org
> Subject: Concatenation Operator in 4GL
>
>
>
> Hi,
>
> I have an SQL statement in a 4GL program:
>
> update summary set (person_name) = ((select first_name || last_name from
> person_table where person_table.person_id = summary.person_id))>
> And I can't pass the compiler! The "||" operator was detected as invalid
> characters.
> But this SQL statement works fine using dbaccess.
>
> I did not find any restriction on concatenation operators in 4GL.
> Could you help? Any work arround?
> TIA
>
> Wendy