Topic: database is locked
Hi
something went wrong with my project.
whatever I do to save a record it says "database is locked"
the version I use is 1.45 which is a freeware
My Visual Database → General → database is locked
Hi
something went wrong with my project.
whatever I do to save a record it says "database is locked"
the version I use is 1.45 which is a freeware
Whether your database is corrupted or you are trying to do 2 actions at the same time within your project. Did you have a system crash whilst your project was running?
Hello.
This problem disappears if restart application?
I remember that there is some bug in the old version related with this error.
Hello,
I'm facing the same problem. The database is locked while trying to save a record. The problem disappears on restarting. MVD Version 5.4. How to solve the issue?
Hello,
I'm facing the same problem. The database is locked while trying to save a record. The problem disappears on restarting. MVD Version 5.4. How to solve the issue?
Hello.
Do you use your database for multiple users on local network?
No. A single user on a desktop machine.
No. A single user on a desktop machine.
Wrong script may be the cause, please attach your project.
are you using MySql or the local Sqlite?
On Sqlite, a lock occurs when you are trying to read/modify a row at the very same time it is getting modified by the current action. So I guess, you have a refresh action in your scripts or form(s) trying to refresh the data at the very same time you are modifying it with the "Save record" action. The lock is telling you that the data you are trying to modify cannot be performed because another process is currently trying to do something else, most often it is a delete action during an update or a select in the same table you are modifying.
if you use SQLite and SQLQuery() you must free used DataSet.
SQLQuery('select a from b', tmpDataSet); // database is locked
...
tmpDataSet.Free // database is unlocked
My Visual Database → General → database is locked
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi