At 08:22 PM 24/11/2008, you wrote:

>Thank you to everyone. One problem that each answer has though is
>that Firebird seems to check the records first before actually
>inserting the data and therefore still brings up the Violation of
>PRIMARY or UNIQUE KEY constraint "INTEG_36" on table "TBL_INVENTORY"
>error. Any other ideas?

It looks as though INVENTORY_ID is not the only column in the primary key of TBL_INVENTORY...is STOCK_CODE part of it too?

Or do you perhaps have another column in TBL_INVENTORY that is constrained by a UNIQUE constraint?

./heLen