Page 1 of 1

MYSQL and lock

Posted: 25.06.2007, 09:13
by 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

Re: MYSQL and lock

Posted: 25.06.2007, 11:01
by marcocot
marcocot wrote: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