Subject RE: [IBO] 'Mutliple records inserted' error
Author Jason Wharton
> I am using TIB_Cursor with a naturally updatable view. This view has a
> before insert trigger to take care of pre-filling certain fields. For
> reasons that escape me Firebird is reporting 2 rows inserted when in
> fact only 1 is. This causing me undue worry. What is a problem is
> that TIB_Cursor is throwing an exception telling me that multiple rows
> were inserted. I can think of situations where I might use a trigger
> to deliberately insert multiple records with a single INSERT
> statement. It seems that TIB_Cursor ought to treat me like an adult
> and allow me to check if multiple records were inserted and act
> appropriately. As it is I can't get these records inserted. How do I
> get around this?

I think you will have to use a stored procedure to perform the edit.