Topic: the MVD application in a LAN network problem
I am using the MVD application in a LAN network and the result is having a problem with the database being locked when one of the users inputs data. is there a solution to my problem?
My Visual Database → Database applications → the MVD application in a LAN network problem
I am using the MVD application in a LAN network and the result is having a problem with the database being locked when one of the users inputs data. is there a solution to my problem?
For full multi-user access, use the MySQL DBMS
I use multiuser, the database uses sqlite. does sqlite not allow for LAN network?
Work over the network is supported, but there is a problem of blocking the database at the time of writing (and sometimes editing) data. This is due to the fact that the database has a file nature.
Also at the code level, a SQLQuery() command can cause a lock. Therefore, it is strongly recommended to free DataSet right after using.
How to free DataSet right after using??
var
tmpDataSet:TDataSet;
begin
SQLQuery('SELECT name FROM table',tmpDataSet);
try
// some code for get data from dataaset...
...
//
finally
tmpDataSet.Free;
end;
end;
Sqlite is not multiuser per se, you can read data from multiple places but only one user can record data at a time. Sqlite is not recommended in multi user usage as data consistency is at risk when data recording is not guaranteed as it is with an RDBMS like MySQL or MariaDB or MSSQL Server to name only a few compatible with MVDB.
var
tmpDataSet:TDataSet;
begin
SQLQuery('SELECT name FROM table',tmpDataSet);
try
// some code for get data from dataaset...
...
//
finally
tmpDataSet.Free;
end;
end;
k245, thanks you.. I wil try this code
tcoton, thanks you for your advice I will try use MySQL too
My Visual Database → Database applications → the MVD application in a LAN network problem
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi