Database locks.....

[Morpheus1981]

We got an application that always generate locks on the database. No one can use others apps. because this application is locking. But the person who is using the application(the one which is locking) is doing nothing but consulting information. How can I prevent that to happen in Delphi(5).

 

[svanels]

What database are you using?

Try to use queries, by nature queries are read-only, unless you prepare them to modify data.
Another way is creating views on the database (sql-server, interbase, orcale etc). Views are read-only snaphots of the tables, and delphi would handle them like (read-only) tables.
You could prepare different views for different users, for security reasons.

Regards Steven van Els
SAvanEls@cq-link.sr