Locktable issue

vikram7_dabas

I m using the Base database(4.0 SP3) I want when the table will Lock and when it is showing message(i.e.,The table is locked)I want the username name should appear there.What I have to do?

kriki

You can't control that in any way.
With the the Navision-DB, it gives the locking user by default. On SQL you it doesn't show who is locking.

But in the sessions-table, you can see who is blocking who.

vikram7_dabas

I m using SQL DB but in sessions table how I willknow that who blocks whom?

kriki

vikram7_dabas wrote:

I m using SQL DB but in sessions table how I willknow that who blocks whom?

You need to create a new form on table Session. In it are some fields "Blocking Connection ID","Blocking User ID","Blocking Host Name" that tells you everything about who is blocking the current user.

vikram7_dabas

When we have to run this report.

kriki

At the moment they are locked.
This might be useful: http://www.mibuso.com/howtoinfo.asp?FileID=19