Re: Concatenation Operator in 4GL

Posted in 1999

Octav Chiriac — Wed, 13 Oct 1999 17:19:19 +0200 — source: Informix-list mailing list archive (1991-1998)

PREPARE .. EXECUTE ? Best Regards, Octav Wendy Zheng wrote: > > 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 -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com