Hi Karen,
For reference although the RECORDLOCKU statement does not support an
array in it's syntax it does read the record on UniVerse, it does not on
UniData. Your assumption is correct that it shouldn't read the record, as
it only needs to access the lock table which is a memory
I am certainly NOT trying to change anyone's coding style, I am just
curious
IMPRESSIVELY POLITICALLY CORRECT ;-)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I assume that the SUB.LOCKED.SOH.RO is called to do the lock and then
returns.
The problem is that you open the file in this routine to do the locking
against. Once this subroutine ends that file handle will go out of scope
(it was defined local to this subroutine) and the file is closed. That
I feel I am missing something. Why is a READU LOCKED not used?
Bruce M Neylon
Health Care Management Group
Brutzman, Bill [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/07/2008 11:00 AM
Please respond to
u2-users@listserver.u2ug.org
To
'u2-users@listserver.u2ug.org'
why not do a READU using the LOCKED clause? Something like
READU ORDER.ITEM FROM F.ORDER LOCKED
PRINT 'record is locked ..'
INPUT JUNK
END ELSE
* I got the record AND locked it, so do my thing .
END
you could even loop around a couple of times to see if the lock releases
and
Do I need a READU if I am already using a RECORDLOCKU command?
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, May 07, 2008 11:34 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record Locking Problems
I
@listserver.u2ug.org
Subject: Re: [U2] Record Locking Problems
I feel I am missing something. Why is a READU LOCKED not used?
Bruce M Neylon
Health Care Management Group
Brutzman, Bill [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/07/2008 11:00 AM
Please respond to
u2-users@listserver.u2ug.org
To
'u2
PROTECTED]
Sent: Wednesday, May 07, 2008 10:34 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record Locking Problems
I feel I am missing something. Why is a READU LOCKED not used?
Bruce M Neylon
Health Care Management Group
Brutzman, Bill [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED
Subject
RE: [U2] Record Locking Problems
Do I need a READU if I am already using a RECORDLOCKU command?
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, May 07, 2008 11:34 AM
To: u2-users@listserver.u2ug.org
Subject
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Wednesday, May 07, 2008 11:18 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Record Locking Problems
Do I need a READU if I am already using a RECORDLOCKU command?
--Bill
-Original Message-
From: [EMAIL
@listserver.u2ug.org
Subject: Re: [U2] Record Locking Problems
I feel I am missing something. Why is a READU LOCKED not used?
Bruce M Neylon
Health Care Management Group
Brutzman, Bill [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/07/2008 11:00 AM
Please respond to
u2-users
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Record Locking Problems
I think he's using the recordlocked and recordlocku syntax to illustrate
his problem. From the documentation that I've read on those two commands
(which I'd never seen before today), this should work.
Karen Bessel
Software
Bill,
The RECORDLOCKED returns a number of values, the value of 1 states that
this user has a record lock, not another user.
Try using an else on the case structure.
Cheers,
David Murray
*
Learn and do
* Excel and share
http://u2blog.org
-Original Message-
Your code doesn't test for the type of lock. It could be just a shared
record lock which would allow another user to get in.
Jerry Banker
Senior Programmer Analyst
IBM Certified Solutions Expert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman,
Bill
I think your problem is related to re-opening the file in the subroutine.
Everytime you open a file you clear all the previous locks. Ie the user
opens file, locks record and then opens file again there is no record locks.
Use a fileinfo statement to check file is open and if it is skip
15 matches
Mail list logo