On 16 Feb 2005 at 23:25, Peter Lee wrote:

>with barcodes, one with products. On the products table, I have a
>trigger that after insert, grabs an unallocated barcode and assigns it
>to the new product.

Because your trigger _after_ insert.
--
SY, Dimitry Sibiryakov.