I really, really need transaction, not row, triggers. There's been discussion of those here in the past (IIRC D.R. Hipp had a proposal once).
Here's what I need: - at transaction time I need a way to record somewhere that the transaction did start. This would mostly be an insert into a table with an INTEGER PRIMARY KEY AUTOINCREMENT column, and a time of transaction start. I can do without this by simply doing an insert into that table if the relevant row didn't already exist. - at transaction commit time I need to be able to RAISE() exceptions if the concluding transaction does not meet certain requirements. I.e., SELECT RAISE(ROLLBACK, 'Error: user did not x, y, or z') WHERE <various sub-queries>. I have no way to detect end of transaction time, so I can't really do without this :( I'd also like to be able to do inserts/updates/deletes at transaction commit time, as if the application's COMMIT has been a savepoint, but I could live without this capability. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
