Subject 'Mutliple records inserted' error
Author Stephen Boyd
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?