Hi All,

I Just try migrate from using BDE to IBX. For use live query I already use
TIBQuery conjunction with TIBUpdateSQL.

The IBQuery is :

'SELECT
RECID,NOREFF,AMOUNT
FROM SALES'

The IBIpdateSQL is :

DeleteSQL :
DELETE FROM SALES
WHERE RECID =:OLD_RECID

InsertSQL :
INSERT INTO SALES
(NOREFF,AMOUNT)
VALUES
(:NOREFF,:AMOUNT)

ModifySQL :
UPDATE SALES
SET
NOREFF=:NOREFF
AMOUNT=:AMOUNT
WHERE RECID=:OLD_RECID

When I use : "Database1.ApplyUpdates([QrSALES]) ;" after inserted data, it's
working good. The data is commited.

But where I use the "Database1.ApplyUpdates([QrSALES]) ;" after edit or
delete, there's error message :

'UPDATED FAIL. USER ABORT'

and the query is rollback.
What's wrong with my code ? There's I mis something ?

Thx,
Monalisa.