Hi,
Delphi 10. Firebird 3.x IBDAC
using query like SELECT * From Chat and DLM Statements :
INSERT INTO CHAT
(ID, IDUSER, IDUSERTO, IDUSERFROM, DATETIME, MESSAGE, ISNEW)
VALUES
(:ID, :IDUSER, :IDUSERTO, :IDUSERFROM, :DATETIME, :MESSAGE, :ISNEW)
Or
UPDATE CHAT
SET
ID = :ID, IDUSER = :IDUSER, IDUSERTO = :IDUSERTO, IDUSERFROM = :IDUSERFROM, DATETIME = :DATETIME, MESSAGE = :MESSAGE, ISNEW = :ISNEW
WHERE
ID = :Old_ID
RowsAffected Is Always 0 with append or edit commands StrictUpdate := True;
QueryRowsAffected := True;
creating a update DML In a IBCQuery end execute it the RowsAffected is woking fine
AI Chat has given me all possible solutions all done based on the instructions but no luck