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
Received on Wed May 11 2005 - 05:29:19 CDT
