Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Record lock info - convert the number to key
Thu, May 14 2015 2:42 AMPermanent Link

durumdara

Dear Support!

2.11B3.

We have a place where they got lock error on table rows.
We must know who locks the actual row.

The ServerSessionLocks table is able to show the row locks on a table, but the Number field is uninterpretable for me.
How to I convert this number to concrete row?

For example:

try
 Work.Edit;
except
 ThisRowNumber = Work.RowNumber(????);
 UserName := SearchForLocks('work', ThisRowNumber);
 ShowMessage('The user: ' + UserName + ' locks this row!');
end;

Can you help me how to interpret and use Number field to get the real record?
This table have primary key, a serial/autoinc/generated field.

Thanks!
Thu, May 14 2015 12:40 PMPermanent Link

Barry

Image