Re: sequence numbers

> > You need to lock the row so no one else can select & update it at the
> > same time.
> >
> > SELECT ...
> > FOR UPDATE
> >
> > UPDATE ...
> >
> > COMMIT;
> >

I've run with this for simplicity, it works like a charm. Thanks. Received on Tue May 21 2002 - 03:52:19 CDT