On May 18, 2005, at 6:02 AM, D. Richard Hipp wrote:
Question: Might it be that you really want to know if SQLite is in auto-commit mode or not? That is a very different thing and is a much easier question to answer.
Yes, I have the same need and that is exactly what I want to know. I am currently considering exposing the autoCommit flag to my code, but perhaps there could be an API call that did it for me. And I guess you can tell I was the one who made the feature request for knowing when we are in a transaction and now I see that what I really want to know is whether or not autoCommit is true of false.
I guess what I'm doing is simulating a database system that doesn't auto-commit by default. Knowing when SQLite is in auto-commit mode (or not) lets me decide whether or not I need to explicitly turn auto- commit off by issue a BEGIN.
