From: milica.mihac@ck.htnet.hr   
      
   I find what was a problem..   
   I changed CursorLocation  in TADOQuery from clUseClient u clUseServer and   
   now everything works OK.   
      
   Anyway thanks.   
   Regards, Milica   
      
   "Paul"  wrote in message   
   news:79e481d3bl3cs0nh4u325kbegjdqosiio6@4ax.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)