**
I am considerning setting up a scheme to lock records when being edited by a user. I came across an old RxPress article (Volume4, Number1, 1996) that explains how to do this for ARS 3.x and 4.0.

Couple of questions...

I am on 5.1, so the macro steps that are included in the process would not work on a web enabled system (which I am), has anyone successfully implemented Record Locking with no Macros? Any pitfalls I should be on the lookout for?

What happens if AREscalator fires off some change to the record and the record is in use by another....What will happen? Will the escalation throw an error, or will it work?

Finally, in general, if you have implemented this process, what do you think of it overall?

Warren

Warren R. Baltimore II
Senior Systems Analyst
Information Systems
The Ohio State University Medical Center
1375 Perry St.
Battelle 13-1-125
Columbus, OH 43201
614-293-2315
baltimore-1@medctr.osu.edu
You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

**
Warren,

Have you looked at
Real Refined Resource Scandinavia AB
Products - rrrOnline

rrrLock - Generic Record Locking

Record Locking has allways been something of a problem in ARS. Two persons open the same ticket, and do not get notified about this until they try to save their work.

Just downloading rrrLock and import it into your application, and you are up and running.

We can (almost) guarrantee that rrrLock will not affect any other part of you application, as the the design is very simple. The hundreds of companies that has downloaded rrrLock so far has not reported any problems.


http://www.rrr.se/en/


Regards...Gidd



-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Warren Baltimore
Sent: Tuesday, December 31, 2002 10:06 AM
To: ARSLIST@ARSLIST.ORG
Subject: File/Record Locking


**
I am considerning setting up a scheme to lock records when being edited by a user. I came across an old RxPress article (Volume4, Number1, 1996) that explains how to do this for ARS 3.x and 4.0.

Couple of questions...

I am on 5.1, so the macro steps that are included in the process would not work on a web enabled system (which I am), has anyone successfully implemented Record Locking with no Macros? Any pitfalls I should be on the lookout for?

What happens if AREscalator fires off some change to the record and the record is in use by another....What will happen? Will the escalation throw an error, or will it work?

Finally, in general, if you have implemented this process, what do you think of it overall?

Warren

Warren R. Baltimore II
Senior Systems Analyst
Information Systems
The Ohio State University Medical Center
1375 Perry St.
Battelle 13-1-125
Columbus, OH 43201
614-293-2315
baltimore-1@medctr.osu.edu
You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

**
Unless you code specifically to not show errors by the ARESCALATOR then the escalation will fail. I set up a record locking scheme that did not use any fields on the main form (It used a "Locking" form to record whether a record was locked or not).

The Escalator does not check the "Disable Change Flag" attribute for a field so you will have to watch out for that situation. I have an escalation that just send notifications and should not modify the ticket but it does (I have to do a set fields to a Display Only/Disable Change Flag marked field for formatting and the escalator goes ahead and updates the Last Modified info anyway).

-----Original Message-----
From: Warren Baltimore [mailto:baltimore-1@MEDCTR.OSU.EDU]
Sent: Tuesday, December 31, 2002 12:06 PM
To: ARSLIST@ARSLIST.ORG
Subject: File/Record Locking


**
I am considerning setting up a scheme to lock records when being edited by a user. I came across an old RxPress article (Volume4, Number1, 1996) that explains how to do this for ARS 3.x and 4.0.

Couple of questions...

I am on 5.1, so the macro steps that are included in the process would not work on a web enabled system (which I am), has anyone successfully implemented Record Locking with no Macros? Any pitfalls I should be on the lookout for?

What happens if AREscalator fires off some change to the record and the record is in use by another....What will happen? Will the escalation throw an error, or will it work?

Finally, in general, if you have implemented this process, what do you think of it overall?

Warren

Warren R. Baltimore II
Senior Systems Analyst
Information Systems
The Ohio State University Medical Center
1375 Perry St.
Battelle 13-1-125
Columbus, OH 43201
614-293-2315
baltimore-1@medctr.osu.edu
You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface