Re: [sqlite] question about instead of delete triggers

On Sun, 30 Oct 2005, Dan Kennedy wrote: > When you execute this SQL: "delete from v_items where item='me'", > SQLite essentially does: > > FOR EACH ROW IN "select FROM v_items where item='me'" { > > Execute trigger program > > } That makes perfext sense. Thnx. Rgds, Mark. > --- Mark de Vries

Re: [sqlite] question about instead of delete triggers

When you execute this SQL: "delete from v_items where item='me'", SQLite essentially does: FOR EACH ROW IN "select FROM v_items where item='me'" { Execute trigger program } --- Mark de Vries <[EMAIL PROTECTED]> wrote: > Hi, > > I guess my question is: are conditions in the where clause >

[sqlite] question about instead of delete triggers

Hi, I guess my question is: are conditions in the where clause of a instead of delte trigger ignored if the referenced columns are not in the where clause of the orig delete? But perhaps an example of my 'problem': create table item ( id integer primary key, name text, catid integer