Re^2: SQLite Windows readonl databasey

in reply to Re: SQLite Windows readonl databasey
in thread SQLite Windows readonl databasey

Thank you for your reply.

After some experimenting, this is what I have noted:

Changing to AutoCommit=>0 does not solve the Problem, I still get the same error
I have now noted that the same error is given even if I try to read the database, for example with my $sth = $dbh->prepare("SELECT * FROM DatabaseInfo WHERE ID='1'");!!!

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

Replies are listed 'Best First'.
Re^3: SQLite Windows readonl databasey by thanos1983 (Parson) on Aug 24, 2018 at 13:17 UTC
Hello again Anonymous Monk, 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!	[reply] [d/l] [select]
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]

In Section Seekers of Perl Wisdom