From: primz@gora.si   
      
   MM wrote:   
   > 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   
      
   Maybe you should be really careful about aggregate. You use   
      
   t1.id and t2.nad after SELECT as non-aggregate field   
      
   and   
      
   t2.id and t2.nad in GROUP BY   
      
   t2.id is not necessryy to be equal t1.id in DB processing statement.   
      
   And ofcourse I'm not sure that there is not another catch inside your   
   querry.   
      
   Regards   
       Gokky   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)