flyspeed query locks sqlite database

Avatar
  • updated
  • Completed
Hello:

I am using flyspeedquery to create some queries I run against a sqlite database. I noticed that it locks the database and I cannot make any data changes when flyspeed is connected to the database.

Could you please fix this and remove the lock on the sqlite database, or provide an option to open the db in exclusive or normal mode?

Thank you
Avatar
costa basil
Hello:

No resolution to this yet?

Thank you
Avatar
Anonymous
Sorry for the late response. This problem will be solved in the upcoming version that will be available till the end of this week. The new property "Locking mode" will be available on the Advanced tab of the Connection Properties dialog.
Avatar
Anonymous
The new option "Locking mode" is added to the Advanced tab of the Connection Properties dialog for SQLite connection type. It is set to Shared by default.