Very Computer

Hi folks !

It's me again with my mad problems :

Let's say we have a stored procedure proc_a (a int) that returns int;

And here we have the following Query:

Select client_id, proc_a(count(*)) total
                                     ^^^^^^
                                     Aggregate   Function
from client
group by client_id
               ^^^^^^ Only one field to group by

It seems like syntax correct query (as it is on Informix 7.2x), but 7.3
on NT returns :

SQL Error (-294): The column (total) must be in the GROUP BY list;

Is there any environment setting to correct that dummy situation ?

Sincerely, Alexander
--

Alexander V.Didytch, Kyiv, Ukraine
--
Requirements are like water: they're good to walk on when they're frozen

Fred Brooks

[SNIP]

Quote:> It seems like syntax correct query (as it is on Informix 7.2x), but 7.3
> on NT returns :

> SQL Error (-294): The column (total) must be in the GROUP BY list;

> Is there any environment setting to correct that dummy situation ?

Art S. Kagel