Firebird 5.0 with FastReport (Delphi 12): unknown ISC error 0

[TheBioh4z4rdx 0]

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 😞

Edited October 30 by TheBioh4z4rdx

[Stano 143]

The GROUP BY NF.DOCUMENT part is missing

[Stano 143]

For compiling SQL texts I recommend to use some DB manager. It would print this error directly!

[TheBioh4z4rdx 0]

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.
 

[gkobler 38]

Try the follow

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

This also can happens with functions SUM, AVG, MIN, MAX...