Re: Incrementing sequence number

Posted in 2000

Obnoxio The Clown — Thu, 20 Apr 2000 22:00:03 BST — source: Informix-list mailing list archive (1991-1998)

From: Richard Spitz <Richard.Spitz@ana.med.uni-muenchen.de> > >Obnoxio The Clown wrote: > > > > From: Richard Spitz <Richard.Spitz@ana.med.uni-muenchen.de> > > > >Could the two of you maybe elaborate a little on how to put a lock > > >on a specific row? > > > > With a FOR UPDATE cursor. :0) > >That's what I thought. So it's only possible to do this in a >program, not in pure SQL, like in DBACCESS. I haven't thought this through (no change there!), but maybe you could fake it with a stored procedure? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com