about locking table

117320

can someone tell me what can cause system prompt another user locking the table?because i got this message very often when testing on multiple user.because currently in the process got a lot of process.for example in 1 process insert record,modify record,modify record and delete record from 1 table.
thanks a lot.

kapamarou

If you are referring to Deadlocks then it's simple: User 1 Locks Table A and the Table B. User 2 Locks Table B and then Table A. Each user has locked a table and waits the other one to release the other table.

If you read the manuals and search a lot on this forum you'll find tons of info on why it's caused and how you can solve it...