Jörg,

2 possible solutions:

1.)

assign a handler for BeforePost event.

procedure qryBeforePost(IB_Dataset: TIB_Dataset);
begin
if IB_Dataset.State = dssDelete then begin
// place your code for the update here
....
....
// need to cancel the delete
SysUtils.Abort
end;
end; {qryArtikelBeforePost}

2.)

Type in your update statement in TIB_Query.DeleteSql


Harald