Page 1 of 1

lock a table

Posted: 18.04.2006, 11:26
by spduvalis
Hi,
I would like to know how to lock a table and then execute some queries
(e.g. insert new record) and after that unlock table using one or more queries.
I work with delphi 7 and zeos 6.5.1.
Thank you

Posted: 18.04.2006, 14:55
by btrewern
You could use transactions to do something similar. What database are you using and what exactly are you trying to do?

Regards,

Ben

Posted: 20.09.2008, 23:45
by mparak
Sit back and let MySQL handle the locks and you will be amazed.
Let the technology do the heavy lifting for you.

Mohammed Parak
CAD RETAIL
Durban South Africa
www.cad.co.za