fastreport3.10 has a bug in TfxADOQuery
fastreport3.10 has a bug in TfxADOQuery
my database is oracle9i for windows.
the TfxADOQuery's SQL is
select a.deptno,a.job
from scott.emp a, scott.dept b
where a.deptno = b.deptno
and a.empno >= 100
and a.empno <= 10000
group by a.deptno,a.job
when ADOQuery is opened ,oracle show error as follows.
Runtime error occurred: 979 (ORA-00979: not a GROUP BY expression)
when I changed SQL as follows then ok
select a.deptno,a.job
from scott.emp a, scott.dept b
where a.deptno = b.deptno
group by a.deptno,a.job
is this a bug? how to fix?
my database is oracle9i for windows.
the TfxADOQuery's SQL is
select a.deptno,a.job
from scott.emp a, scott.dept b
where a.deptno = b.deptno
and a.empno >= 100
and a.empno <= 10000
group by a.deptno,a.job
when ADOQuery is opened ,oracle show error as follows.
Runtime error occurred: 979 (ORA-00979: not a GROUP BY expression)
when I changed SQL as follows then ok
select a.deptno,a.job
from scott.emp a, scott.dept b
where a.deptno = b.deptno
group by a.deptno,a.job
is this a bug? how to fix?