Re^3: SQLite Windows readonl databasey

You need to remove it completely not set it to zero. As I said this is an assumption based on what I read.

Hope this helps, BR.

Seeking for Perl wisdom...on the process of learning...not there...yet!

Comment on Re^3: SQLite Windows readonl databasey Select or Download Code

Replies are listed 'Best First'.
Re^4: SQLite Windows readonl databasey by soonix (Chancellor) on Aug 25, 2018 at 11:38 UTC
Somehow, to me, this looks like Cargo cult programming. The only mention of `autocommit` in SQLite docs is this, which says Autocommit mode is on by default. Autocommit mode is disabled by a BEGIN statement. Autocommit mode is re-enabled by a COMMIT or ROLLBACK. Basically this makes me think SQLite would ignore any attempt of the application to set such a flag. Update: Of course, were it MySQL, your findings would be plausible...	[reply] [d/l]

Replies are listed 'Best First'.

Re^4: SQLite Windows readonl databasey
by soonix (Chancellor) on Aug 25, 2018 at 11:38 UTC

The only mention of autocommit in SQLite docs is this, which says

Autocommit mode is on by default. Autocommit mode is disabled by a BEGIN statement. Autocommit mode is re-enabled by a COMMIT or ROLLBACK.

Update: Of course, were it MySQL, your findings would be plausible...