From: milica.mihac@ck.htnet.hr   
      
   Hello users. I have a query that I can run and see the result on the grid on   
   design time, but when i run the program i get the folowing   
   message:ORA-00979: not a GROUP BY expression. When I run the same query with   
   out parameters it runs and it was runing well before in Oracle 8.Also If I   
   don't use the GROUP BY function but with the parameter, it works also well   
   ?What is the problem? The query is:select t1.id,t2.nad,max(t2.name) as   
   namefrom c02 t1,d00 t2where t1.id = t2.idand t1.date1>= :pDate1group by   
   t2.nad, t2.idAny help is helpfull.  Regards,MM   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)