RE: Record Lockup Problem...

[G Armour <garmour400m@xxxxxxxxx>]

I concur with Sean and would add that it isn't that hard to design a
function that would pop up a window in a lock situation that shows the job
(user ID, job number, job name) that has the lock on the record.  This
information is already in the program or file (forget which) status data
structure.

Ditto Sean on why the lock in the first place:  Typical app is a subfile
maintenance program.  The program lists records in a subfile, user selects
one to change (or even view), so the default is to open the file with
update.  When filling the subfile record list or showing a view-only of a
record, the reads and chains should use the "No-update" operation
extender, so that the record is not opened for update.  It's in the
manual.

HTH, GA

--- Sean Porterfield <sporter@xxxxxxxxxxxx> wrote:
> > Problem:  Two users at different workstations have the same
> > record open in a database.
> >
> > User 1 is just viewing the record on their screen.
> >
> > User 2 needs to update or change the open record.
> >
> > User 1 has walks away from their desk and left the record open
> > and displayed on their workstation.
> >
> > User 2's workstation "locks up" waiting for User 1 to close the
> > record so it can be updated.
> >
> > User 2 calls the System Administrator to complain about the
> > workstation being "locked up".
> >
> > It would not be feasible for the System Administrator to go
> > around to each workstation in an attempt to find User 1 and close
> > the record.
> >
> > Is there a way to show the System Administrator the user IDs,
> > workstations, or device names in the situation described above?
> 
> 
> WRKUSRJOB USER2 *ACTIVE   (or WRKJOB if USER2 knows the job name/number)
> 5 to work with, 12 for locks, F10 for record locks.  You'll see the
> offender on the list.
> 
> If USER1 is "just viewing" why lock the record?  Or is USER1 really
> maintaining, but not planning to change anything?
> 
> Also USER2's program could be changed to check for the lock and ask for
> retry y/n.

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com