Re: Database Trigger causing Mutating Table

steve / sybrand,

thanks very much for the pointer, i now see the error of my ways.

however, i have another question relating to this (solve one problem and another comes along!)

i also require to update the status of other records in the table when certain situation occur.

for example, in the orders table, when all orders for a certain ORDER_RECEIVED_DATE are dispatched, update the status of all orders for that date to 'ALL DISP', when the LAST one is dispatched.

this means i can't just use ...

:new.order_status = 'ALL DISP'

as this only caters for the current order, not the other ones for that ORDER_RECIEVED_DATE. so my question is, how do you write a trigger to update "other" records in the table with the trigger on it.

i hope there is a way around this!!!

thanks again for any help.

japs1.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 29 2000 - 00:00:00 CDT