In article <4239F169.4060806@...>, Alexandre Benson Smith
wrote:

> >We want sequential "admission numbers" in our app to be auto-generated for
> >the user (they need to see them, but getting the next sequential value
> >automatically rather than relying on the data entry people to always
> >accurately know what the next one should be).

How about pre-allocating the numbers, each night run an SP which looks at
the number of 'ready-to-use' records in the table and creates more if
necessary for the next day.

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly