TheBioh4z4rdx

try to do "query.Open" for Select statements instead of "query.Execute()"

I am veryr sorry... I forgot to copy the last part of the "SQL".....

Quote

SELECT NF.DOCUMENT, SUM(NF.TOTAL) AS TOTAL FROM NF GROUP BY NF.DOCUMENT

Unknow ISC error 0 

The error occurs in all reports that use "SUM", when viewing them in "Fast Report"....

DBeaver/IBexpert the "SQL" works normally.
 

When I execute a simple "SQL" with frxDBXQuery within Fast Report, using "SUM" : Unknow ISC error 0
If I remove the "SUM" the "SQL" query works...

Quote

SELECT NF.DOCUMENT, SUM(NF.TOTAL) AS TOTAL FROM NF GROUP BY NF.DOCUMENT

Pls help me 😞