subject:"\[sqlite\] Trigger order"

Re: [sqlite] Trigger order

2005-01-24 Thread Gwendolynn ferch Elydyr

On Mon, 24 Jan 2005, Dan Kennedy wrote: Does SQLite have any specific ordering requirements for how triggers are created? I have a case where an 'UPDATE BEFORE' trigger will not work as expected if an 'UPDATE AFTER' trigger on the same table (but not the same column) is created after it is.

Re: [sqlite] Trigger order

2005-01-24 Thread Dan Kennedy

> > Does SQLite have any specific ordering requirements for how triggers > are created? I have a case where an 'UPDATE BEFORE' trigger will > not work as expected if an 'UPDATE AFTER' trigger on the same table (but > not the same column) is created after it is. Shouldn't do. What are the

[sqlite] Trigger order

2005-01-24 Thread Gwendolynn ferch Elydyr

Does SQLite have any specific ordering requirements for how triggers are created? I have a case where an 'UPDATE BEFORE' trigger will not work as expected if an 'UPDATE AFTER' trigger on the same table (but not the same column) is created after it is. cheers!