Re: Not a group by expression

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" <paulsnewsgroups_at_hotmail.com> wrote in message news:79e481d3bl3cs0nh4u325kbegjdqosiio6_at_4ax.com...
>
> "MM" <milica.mihac_at_ck.htnet.hr> 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.
Received on Thu May 12 2005 - 10:52:26 CEST