From: paulsnewsgroups@hotmail.com   
      
   "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   
      
      
   Kako si? Give us the details of the DDL for the tables in question -   
   also, this question should really be asked on   
   comp.databases.oracle.server. Version number (exact) and OS info would   
   also help. Hvala.   
      
      
      
   Paul...   
      
      
      
   --   
      
   plinehan __at__ yahoo __dot__ __com__   
      
   XP Pro, SP 2,   
      
   Oracle, 9.2.0.1.0 (Enterprise Ed.)   
   Interbase 6.0.2.0;   
      
   When asking database related questions, please give other posters   
   some clues, like operating system, version of db being used and DDL.   
   The exact text and/or number of error messages is useful (!= "it didn't   
   work!").   
   Thanks.   
      
   Furthermore, As a courtesy to those who spend   
   time analyzing and attempting to help, please   
   do not top post.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)