RefreshOptions = [roAfterInsert, roAfterUpdate]
after an insert I get the following SQL in the monitor (older IBDAC version 9.3.0)
INSERT INTO KDMANAG
(KKID, KKKDNUMM, KKZEIT, KKART, KKERLBISDAT)
VALUES
(NEXT VALUE FOR GEN_KDMANAG_ID, ?, ?, ?, ?)
RETURNING
KKID
but in version 10.0.0 the returning clause is missing
INSERT INTO KDMANAG
(KKID, KKKDNUMM, KKZEIT, KKART, KKERLBISDAT)
VALUES
(NEXT VALUE FOR GEN_KDMANAG_ID, ?, ?, ?, ?)
therefore KKID is null after the insert and the refresh produces
Select ..... where KKID is NULL
which causes the "update failed"-error
Please have a look at this.
best regards
Oliver