MYSQL and lock

[marcocot]

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

[marcocot]

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

Generally, How can I lock a row with zeoslib?

Regards
marco