My setup is this I have table A and table B. I have a afterinsert
trigger on table B that could update a record on table A. For example

table A fields
--------------
itemid
itemname
requestqty

table B fields
--------------
itemid
requestdate
request

my trigger on afterinsert on table B is this ...

update table A
set requestqty = requestqty + new.request
where itemid = new.itemid

I have encountered that there are times that after a record was
inserted on the table B... the record on the table A wasn't not updated.

For me this is very annoying it causes my data to be not synchronize.
Is there a bug? Does any one experience this one where sometimes it
seems that the trigger wasn't triggered after all.

Please advise.

Thanks.



james