INSERT INTO buffer2
(ACCID,PaymentNo,GLAccNo,Text,Amount)
SELECT ACCID,999999992,'Test','Test',round(SUM(-Amount),2) AS test
FROM buffer2
GROUP BY ACCID

---

 Comments and Workarounds

---

The workaround is to use a temporary table (SELECT..INTO) for the initial grouped query without the ROUND(), and then use this table for the INSERT statement.

---

 Resolution

---

Fixed Problem on 11/6/2005 in version 4.22 build 1

---

 Products Affected

---

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source