Problem is if a lock was set multiple times within that 5 minute interval, it could look like It had been setup for 5 minutes....when in reality, it could have only been locked for a couple seconds This time.
I guess you could always make that five minutes, down to like 10 seconds or so... George -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wjhonson Sent: Friday, March 23, 2012 12:23 PM To: [email protected] Subject: Re: [U2] Record lock There is no way of which I know, in Universe natively, to figure out what time a lock was set. Years ago, I wrote a job that woke up every five minutes, scoured the lock table, and updated a lock table history file. Then at any time, you could query that history to how long a lock had been open or was yet open. So if this is a consistent problem, you might think of doing that. It doesn't really take a lot of effort, just make sure you test it well. -----Original Message----- From: Mecki Foerthmann <[email protected]> To: u2-users <[email protected]> Sent: Fri, Mar 23, 2012 1:08 am Subject: Re: [U2] Record lock I don't know about Universe but UniAdmin displays the time the lock was et in UD. On 23/03/2012 06:06, Namacha, N. (Nicholas) wrote: Is it possible to know for how long a record has been locked in universe? Kind Regards Nicholas Namacha ******************** Nedbank Limited Reg No 1951/000009/06. The following link displays the names of the Nedbank Board of Directors and Company Secretary. [ http://www.nedbank.co.za/terms/DirectorsNedbank.htm ] This email is confidential and is intended for the addressee only. The following link will take you to Nedbank's legal notice. [ http://www.nedbank.co.za/terms/EmailDisclaimer.htm ] ******************** _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
