SQL Anywhere database - Re: How to determine the related locked table-rows with the result

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: How to determine the related locked table-rows with the result

Greg Fenton

2005-08-25, 3:31 am

JN wrote:
>
> Our problem is, that we need to know which row in the table is locked.

I wonder why it is you feel that you need to know the particular row.

Have you enabled the RememberLastStatemen
t option (or "-zl" on the
engine start up) to see if the blocking connection's last statement
might be the culprit?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links