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. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
