Exclusive Lock (AREV Specific)
At 26 MAR 2003 05:05:32PM S Shavdia wrote:
Is there a way to remove an Exclusive lock on a record if the record is displayed but the station is idle for certain amount of time? We need this to fix a situation where user forgets to release a record even when nothing is being done to the record while other user need to put a lock.
Using AREV 2.12 with NLM.
Thanks.
Sadhana
At 26 MAR 2003 06:56PM Victor Engel wrote:
Probably the only safe thing to do would be to disconnect the user from the console. You could release the lock from the console, but if the user returned and updated the record, you'd have a loss of data integrity.
At 27 MAR 2003 02:18AM Donald Bakke wrote:
Sadhana,
Would having the user be logged off the application be a workable solution? You can easily add this feature to your application.
At 27 MAR 2003 11:52AM S Shavdia wrote:
Don & Victor,
Disconnecting the user won't go smooth as I have more than one user. These group of users basically need to have "Read Only" access but my understanding is if one user has shared lock on the record, no other user can put an Exclusive lock on the same record. If that's not correct is there any other solution?
Thanks
Sadhana
At 27 MAR 2003 12:15PM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
If you simply want to prevent a group of users accessing records via a screen (read only) use this - http://www.sprezzatura.com/revmedia/v4i4a7.htm
World Leaders in all things RevSoft
At 27 MAR 2003 05:25PM Sadhana Shavdia wrote:
Hi Sprezzatura Group,
No I don't need to prevent user from accessing record. I need a routine which can release the record if it's being displayed with no activity for certain amount of time - kind of timeout - so other user can access the record and put an exclusive lock on it. Typically an user leaves a record on screen and disappears for an hour for lunch!!
Thanks.
Sadhana
At 27 MAR 2003 06:10PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Well write a replacement indexing hook that after a nominated time does an UNLOCK ALL and resets the software.
World Leaders in all things RevSoft
At 28 MAR 2003 04:02AM Hippo wrote:
It seems to me you don't know what you want:(
Sprezz gived you everything you need.
Solutions:
1) These users with read only access will use
WC_WLOCKED%=0 and UNLOCK ALL in window setup.
2) Users with normal access, but typical lunch idle will have normal window setup, but replacement background "indexing" process, which will after specified idle set WC_WLOCKED%=0, UNLOCK ALL and MSG('Please don't left comp with opened windows. Changed to Read-only!')
At 28 MAR 2003 01:25PM S Shavdia wrote:
Sprezzatura Group and Hippo, thanks for help, Hippo in your "special" way!
I do not know how "replacement background indexing process with idle time" works. Will try to figure that out. I see the comment "if you simply want to prevent users from accessing records" actually meant users can access records but won't be able to edit by setting WC_WLOCKED% to false.
Sadhana
At 28 MAR 2003 02:02PM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Yup the common variable if set allows people to view but not edit the row FROM A WINDOW.
For background indexing replacements see http://www.sprezzatura.com/revmedia/v2i10a4.htm
World Leaders in all things RevSoft