Detecting Record Locks (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Detecting Record Locks (AREV Specific) ====
=== At 14 JUN 2004 10:04:54AM Clay Borne wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I've been working on a process that would detect who is locking a particular record.  I've been trying to use the mfs.  I tried putting the code in the READ.RECORD section.  However, I am having problems with it detecting the key being accessed, I don't think the record has become the @RECORD at this point.  I also tried putting the code in the LOCK.RECORD section, that too gave me grief.  Does anyone have any ideas on this?  It is a simple procedure that just gets the key of the @record, the username, and date time and writes it to table.  Your thoughts would be appreciated.
</QUOTE>
----

=== At 14 JUN 2004 10:09AM support@sprezzatura.com wrote:  ===

<QUOTE>Well putting it in the lock.record section stands a better chance of working than putting it in the read.record section. However these is also the issue of local lock tables to contend with. What was the problem with Lock.Record?



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 14 JUN 2004 10:31AM dsig@sigafoos.org wrote:  ===

<QUOTE>Clay,



The LOCK.RECORD sub *is* the place to put it.  What happens to make this not viable.



Since this is 'Arev Specific' i can assume you are using Arev? (sometimes this doesn't seem to be the case :-).  Also what version of the MFS shell are you using?



dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"


[url=http://www.sigafoos.org/samweb]DSig's Radio Free Oregon[/url]


David Tod Sigafoos ~ SigSolutions

</QUOTE>

----

=== At 14 JUN 2004 02:02PM dsig@sigafoos.org wrote:  ===

<QUOTE>Sorry the last post was so short .. 



As mentioned the LOCK.RECORD should be what you use.



As for your problem with the READ.RECORD



]] I've been working on a process that would detect who is locking a particular record. I've been trying to use the mfs. I tried putting the code in the READ.RECORD section. However, I am having problems with it detecting the key being accessed, I don't think the record has become the @RECORD at this point



You are correct about @RECORD.  here is what the MFS should be showing you.



On coming into the mfs for READ (or reado) you should have the following:



CODE   =1 (2 for reado)

BFS    =MFSNAME@vmRTP57

HANDLE =00000000011volume\rev10001.lk

NAME   =id (id of what you are reading)

FMC    =unassigned

RECORD =null

STATUS =unassigned



after the NEXTFS call you should have something like 



CODE   =1 (2 for reado)

BFS    =MFSNAME@vmRTP57

HANDLE =00000000011volume\rev10001.lk

NAME   =id (id of what you are reading)

FMC    =unassigned

RECORD =full contents of record being read

STATUS =1 (if read was okay)



I have a little routine which will display the values at all times in a mfs if you want it













dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"


[url=http://www.sigafoos.org/samweb]DSig's Radio Free Oregon[/url]


David Tod Sigafoos ~ SigSolutions

</QUOTE>

----

=== At 14 JUN 2004 06:50PM dsig@sigafoos.org wrote:  ===

<QUOTE>opps .. forgot to mention you can get the mfs a href=ftp://ftp.sigafoos.org]here[/url]



It is in dos format so to get into Arev .. 



COPY DOS 'where_you_put_it\dsigmfs.mv (R) TO:(BP DSIGMFS



then compile and use as you want.  It does post a message for every even in the mfs .. just a warning



dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

[url=http://www.sigafoos.org/samweb]DSig's Radio Free Oregon

David Tod Sigafoos ~ SigSolutions

</QUOTE>

----

=== At 14 JUN 2004 06:52PM dsig@sigafoos.org wrote:  ===

<QUOTE> .. i give up .. loo long a day .. 



ftp.sigafoos.org 



dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

[url=http://www.sigafoos.org/samweb]DSig's Radio Free Oregon[/url]

David Tod Sigafoos ~ SigSolutions

</QUOTE>

----

=== At 16 JUN 2004 11:00AM Clay Borne wrote:  ===

<QUOTE>Thanks for all the help!

</QUOTE>

----

=== At 16 JUN 2004 01:12PM dsig@sigafoos.org wrote:  ===

<QUOTE>So, did you get the mfs to trap delete as needed?



dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

[url=http://www.sigafoos.org/samweb]DSig's Radio Free Oregon[/url]

David Tod Sigafoos ~ SigSolutions

</QUOTE>

----

=== At 24 JUN 2004 06:07PM thingy wrote:  ===

<QUOTE>I just write a 40 line program which lists all locks and who has them.

Got the idea from NLM_STATS.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=4E7E1DCB15E8726D85256EB3004D5A9B|View this thread on the  forum...]]