Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Record lock info - convert the number to key |
Thu, May 14 2015 2:42 AM | Permanent 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 PM | Permanent Link |
Barry | durumdara,
Does this thread help? http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&msg=11682 Barry |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |