On 25/08/2013 23:40, tim.wickett wrote:
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.
Rick Hillegas rick.hille...@oracle.com writes:
On 8/25/13 2:40 AM, 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
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
value is updated. I want a history of each location an item of waste has
been stored at.
--
View this message in context:
http://apache-database.10148.n7.nabble.com/More-trigger-problems-tp133437p133441.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.