Re: [U2] Record Locking Problems

2008-05-08 Thread Richard Taylor
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 r

RE: [U2] Record Locking Problems

2008-05-08 Thread Dennis Bartlett
>> 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/

Re: [U2] Record Locking Problems

2008-05-08 Thread Jonathan D Smith
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 structu

RE: [U2] Record Locking Problems

2008-05-07 Thread David Jordan
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 o

RE: [U2] Record Locking Problems

2008-05-07 Thread JPB-U2UG
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, Bi

RE: [U2] Record Locking Problems

2008-05-07 Thread David Murray
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

RE: [U2] Record Locking Problems

2008-05-07 Thread Thomas Derwin
CTED] Behalf Of Bessel, Karen Sent: Wednesday, May 07, 2008 09:24 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

RE: [U2] Record Locking Problems

2008-05-07 Thread Allen E. Elwood
008 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] 05/07

RE: [U2] Record Locking Problems

2008-05-07 Thread Bessel, Karen
: [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- Fr

RE: [U2] Record Locking Problems

2008-05-07 Thread BNeylon
g.org'" cc 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-user

Re: [U2] Record Locking Problems

2008-05-07 Thread doug chanco
On Behalf Of [EMAIL 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" <[E

RE: [U2] Record Locking Problems

2008-05-07 Thread Bessel, Karen
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] 05/07/2008 11:00 AM Please respond to u2

RE: [U2] Record Locking Problems

2008-05-07 Thread Brutzman, Bill
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

Re: [U2] Record Locking Problems

2008-05-07 Thread doug chanco
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 a

Re: [U2] Record Locking Problems

2008-05-07 Thread BNeylon
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'" cc Subject [U2