RE: Concatenation Operator in 4GL

Posted in 1999

Rekaish Bhardwaj — Wed, 13 Oct 1999 16:23:00 +0100 — source: Informix-list mailing list archive (1991-1998)

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