Hi again, I am having more trigger problems. This time I am trying to create
a history when values are updated. This is my code
CREATE TRIGGER update_location
AFTER UPDATE ON WASTE_ITEM
REFERENCING OLD AS old_waste_item
FOR EACH ROW
WHERE (old_waste_item.current_location
On 25/08/2013 12:40, tim.wickett wrote:
Hi again, I am having more trigger problems. This time I am trying to create
a history when values are updated. This is my code
CREATE TRIGGER update_location
AFTER UPDATE ON WASTE_ITEM
REFERENCING OLD AS old_waste_item
FOR EACH ROW
I still get the syntax error if i have the WHERE clause after the triggered
statement.
The idea of the code was to create a new entry in the
WASTE_ITEM_LOCATION_HISTORY table every time the current_location value was
updated in the WASTE_ITEM table. However I don't want an entry if any other
Thanks, Bryan,
I've cut the program down to bare bones. Can you run -verbose:class while
in NetBeans? I downloaded the Process Manager but haven't had time to work
with it. I agree that the problem is subtle. I'll work on it some more
tomorrow. Again, as always, thanks for your help!
Best