On Apr 22, 2008, at 10:22 AM, G Jones wrote:

>> Depending on your Ingres version you can also use a CASE statement in
>> the SQL
>
> Something to watch out for if you're using ABF/4GL, I don't think you
> can use the case statement. Certainly with Ingres 2.6 it's not
> recognised, and I think - please correct me if wrong - this is still
> the case (pardon the pun) with the latest release.

I do believe that's still true. However, if you want to badly enough,
you can stuff the query into a string and execute immediate the
string. That won't work for selects, so it doesn't help the OP, but
it's a workaround for non-select queries.

Ideally ABF would learn about CASE. Sounds like a community project
to me...

Karl