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

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 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

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'

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

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 Bessel, Karen
@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

Re: [U2] Record Locking Problems

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

RE: [U2] Record Locking Problems

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

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- From: [EMAIL

RE: [U2] Record Locking Problems

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

RE: [U2] Record Locking Problems

2008-05-07 Thread Thomas Derwin
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

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 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,

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