db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "tim.wickett" <...@nextech-technology.co.uk>
Subject Re: More trigger problems
Date Sun, 25 Aug 2013 20:40:34 GMT
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.

Mime
View raw message