Devart Forums

Hi,

I have some tables updated via views (view triggers). In one case I get constantly an error message
"Updtae failed. Found 0 records." What may be the reason ?

IBDAC 3.10.0.7 / Firebird 2.1.2

This error is raised if the RowsAffected property is 0 after the update query is executed.

If your table is updated successfully but you get this error, set the StrictUpdate option of TIBCQuery to False to disable checking RowsAffected.

The application is connected to views via TIBCTables. Each view directly in the database has beforeupdate trigger and IT updates the table actually. Usually it works all right, with one exception. The table which generates exception looks like the others, nothing special. All TIBCTables properties are set the same. It looks like the database file isn't corrupted too. Directly in the database the update works correctly . So.. any other hints ?

Just set the StrictUpdate option to False.

Seting StrictUpdate option to False doesn't help. Error message disappears but the record isn't actually updated or deleted.

I have walked around the problem with TIBCUpdateSQL as UpdateObject in TIBCTable.

I've noticed the problem occurs when a field of type numeric(15,9) has any positive value. When null or 0 there's no problem. When positive it looks like the delete or update trigger in database doesn't see any params (??)

Probably the problem is related to the code of your triggers.

Before delete trigger looks like that:

CREATE TRIGGER MY_TRIGGER FOR TABLE
ACTIVE BEFORE DELETE POSITION 0
AS
begin
DELETE FROM TABLE WHERE ID = OLD.ID;
end


not too complicated

Maybe the problem occurs because DELETE query is executed twice:
First in the trigger, then the server tries to delete the record because it executes the main DELETE query that was sent by TIBCTable.