On 23 Jun 2010, at 5:19pm, b s wrote: > I don't know when transaction > begins or ends!
You are still ignoring the fact that transactions can be nested. One specific INSERT command might be a member of three different transactions. Your model allows only for one transaction per command. If you have your own model of transactions, just do it all with triggers: store a value somewhere for which transaction you're on, and have the triggers copy this value and put it into your log. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
