MYSQL and lock
Posted: 25.06.2007, 09:13
Hello to anyone,
I need lock a record to prevent other uses to modify/delete it. I use SELECT.. FOR UPDATE using TZquery. The problem is the second user stand still waiting for the first user to commit or roll back its transaction and the application freezing. I there a way to break this waiting? Maybe setting zconnection properties, but how?
Thanks
Marco
I need lock a record to prevent other uses to modify/delete it. I use SELECT.. FOR UPDATE using TZquery. The problem is the second user stand still waiting for the first user to commit or roll back its transaction and the application freezing. I there a way to break this waiting? Maybe setting zconnection properties, but how?
Thanks
Marco