CHECK IF MYSQL TABLE OR RECORD IS LOCKED

[123jon]

I am using VB6 to add records to a MySQL database. I would like to know how to check if a table or record is already locked.


See the code below :--

sSQL = "Update ItCustmr Set...etc. etc."

'BEFORE LOCKING I WOULD LIKE TO CHECK IF THE TABLE 'ITCUSTMR' IS ALREADY LOCK.

adoDatabase.Execute ("LOCK TABLES ITCUSTMR WRITE&quot 'Locking table

adoDatabase.Execute sSQL 'Update Table

adoDatabase.Execute ("UNLOCK TABLES&quot ' UnLocking table

 

[123jon]

I am using MyISAM Tables.