Just sent this to Marco:
I always set AutoCommit = True when connecting to a SQLite file that is hosted by CubeSQLServer. This is so that file acts like a native SQLite file when doing INSERTS, UPDATES and DELETES. This way I don't have to use COMMIT unless I explicitly create a TRANSACTION. But this has a very serious consequence! If I do a TRANSACTION, ROLLBACK will not work! I never noticed this until last night. The way I have to work around this is to set AutoCommit = False before starting a TRANSACTION, and then set AutoCommit = True after any ROLLBACK or COMMIT. Do you know about this?
Actually, I suspect that explicitly written Transactions don't even work if I set AutoCommit = True. But setting AutoCommit = True lets me do INSERTS, UPDATES and DELETES without doing a Commit each time. Otherwise, CubeSQL is always in Transaction mode and requires explicit Commits.