Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-(
Bill > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Thursday, June 16, 2005 11:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/R... > > Charles: > > I'm thinking of instead of a: > > READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 > > do something like: > > LOCK 50 > READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 > > Then make sure this is either an include or a subroutine used > by everything that needs a particular unique sequence no. In > this case, everyone gets the momentary lock they need and > transaction bracketing doesn't break the locking mechanism. > > Bill > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, > > Charles > > Sent: Wednesday, June 15, 2005 8:55 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION > > START & COMMIT/R... > > > > From: Bill Haskett > > > I wonder if the same issue (transactions don't release > record locks > > > until they're committed) applies to the LOCK/UNLOCK statement? > > > > No, those are independent of transactions. > > So could they be leveraged for the question posed here? > > . . . I don't see it. > > > > cds > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/