Re: Problem with Informix 7.3

I think the function used in a select clause should be a group function. I am surprised to know how it works in NT (7.2) and SCO Unix ! I need to try it tomorrow. DEEPAK RAJ PATEL <d_patel123@usa.net> wrote in article <705s5i$7hu$1@news.xmission.com>... > > Hi there, > > We are facing a problem with the following query. We've developed it using > Informix On-line workgroup Server 7.2 on Windows NT and it's running fine. > Also it is running fine on Informix On-line Dynamic server on Sco unix. > > But When we tried to port it on to the production environment, with > Informix dynamic server 7.3 on SCO Unix, it is coming out with the > following error. > > "the column expression must be in the group by list" > > Any help is greatly appreciated. > > Deepak > ------ > > select code, sp_test(sum(value)) from sample group by code ;> The query calls stored procedure sp_test. > > procedure sp_test : > > create procedure sp_test(ai_value int) returning int ;> begin > retun ai_value ; > end > end procedure > > the structure of the table sample is > > sample > ( > code char(1), > value int > ) > > > > ____________________________________________________________________ > Get free e-mail and a permanent address at http://www.netaddress.com/?N=1 >