On 21/07/2017 18:13, petern wrote:
a programming pattern that is missing in SQLite trigger body: "if (new.C1<> old.C1) then <SQL statement>". It can be simulated for updates ("update ... where ... and new.C1 <> old.C1") but not for inserts ("insert" has no "where" clause).Maybe so. But, INSERT can accept data rows from a SELECT statement which both does have a WHERE clause and is aware of the trigger body variables.
Quite right! Didn't think of this. Now, all invidual triggers have been gathered into a single one.
Thanks JL _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
