Re: String concatenation in 4gl

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. 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 Carlos. -- Carlos Costa e Silva (minimal@mail.telepac.pt) Peter Tashkoff <TASHKOP@kiwi.co.nz> wrote in article <4v0hcg$s5q@cssun.mathcs.emory.edu>... : It's a day for questions... : In sql you can do this : : select a || b as c, sum(d) from e group by 1 : : In our legacy system we need to group by >16 levels : and so want to do the above but can't figure out how : to do it in 4gl. It's possible that we could code this : in an SP as a workaround. : Any advice much appreciated. : : Thanks in advance : -- : -- : Peter Tashkoff : NZ Kiwifruit Project Consultant/DBA : Marketing Board. Standard Disclaimers apply : This posting may not be used by any commercial : organisation to vilify another. : : :