Re^2: SQLite UPDATE table lock

in reply to Re: SQLite UPDATE table lock
in thread SQLite UPDATE table lock

Thanks for the suggestion. Placing the $sth->finish before the update call worked. I should have had COUNT(*) too (that was a typo) so a fetchrow()worked in that instance.
Thanks

Comment on Re^2: SQLite UPDATE table lock Select or Download Code

Replies are listed 'Best First'.
Re^3: SQLite UPDATE table lock by mje (Curate) on Jul 23, 2012 at 16:03 UTC
If you change to select count() and call fetchall you should not need to call finish. Generally speaking, if you are calling finish it should be an indication that you /might/ be doing something wrong.	[reply]

In Section Seekers of Perl Wisdom