On 23 Oct 2009, at 3:00am, D. Richard Hipp wrote: > On Oct 22, 2009, at 9:11 PM, Simon Slavin wrote: >> > >> So now my original query comes down to this: if a column's value is >> generated by SQLite rather than being supplied by my INSERT command, >> i.e. if the column has a is INTEGER PRIMARY KEY, or has a DEFAULT >> value, can I rely on being able to access that value in my TRIGGER as >> NEW.columnName ? > > AFTER triggers only. With BEFORE triggers, the NEW.columnName value > might not have been generated yet.
Many thanks. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
