Re: String concatenation in 4gl

Carlos Costa e Silva (minimal@mail.telepac.pt) wrote: : It's a surprise that : select a || b as c, sum(d) : into x, y : from e group by 1 : doesn't work in 4gl. Not so surprising, since the concatenation operator was only added in Version 5, and 4GL (even version 6) is based on version 4 capabilities. What's sort of surprising is that you can do it in SQL. I forget why, but I'm sure Jonathan knows... And like most post-version4 features (like stored procedures), you can still prepare and execute it, as mentioned. : As a workaround, you can do: : let wtxt = 'select a || b, sum(d) from e group by 1' : prepare wcurs from wtxt : declare curs_a cursor for wcurs : open curs_a : fetch curs_a into c, d : close curs_a : free wcurs June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Oakland ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.