Greg Stark wrote:
On a related issue, does anyone know if nested transactions are planned for SQLite?
We most probably won't be seeing nested transactions in the near future. The issue has come up a few times before :) It seems to be a common practise to wrap Sqlite with a wrapper library before using. If this is something you did, you can just count the transaction levels yourself. That's what I've done. The catch with doing simple transaction counting is that a rollback rolls back your topmost transaction. But according to SQL Server documentation, that's how MS does it too ( I don't know how Oracle does it ). Regards, Kervin