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 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.
