Re: Locks rows

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Tue, 21 Jan 2003 00:10:41 +0100
Message-ID: <b0hvro$s7k$1@news.hccnet.nl>

> >
> > To implement what Francky may need though, he may need to always use
> > "select ... for update" so that in his situation (some serialized
> > activity) he blocks until the row is completed. Correct?

Another option would be to create a second ('mirror') table, and upon selection immediately transfer the selected row into the other table. On the other hand, you'll also need a way of 'unselecting' then, otherwise you'll end up with no selectable records at all!

Peter Received on Mon Jan 20 2003 - 17:10:41 CST