Baruch_Menachem - 2:24 am on Dec 5, 2010 (gmt 0)
I want to check the quantity of a good before we ship with a trigger that will fire a message that there isn't enough stuff if the quantity purchased is more than the inventory.
So here is a trigger on the inventory table.
for some reason, it won't recognize my table correctly.
In my stockqty is a valid field in inventory.
reate trigger InventoryUpdateTriggerTRG on inventory
@myInventoryID as integer,
@myQTY as integer;
if update (stockqty)
print ' not enough goodies to go around.'
print ' We might want to re order'