Re: Storing of Serial Number

Posted in 2005

nobody — Sun, 06 Mar 2005 09:31:18 -0600 — source: Usenet: comp.databases.informix

Art S. Kagel wrote: > Andrew Hamm wrote: > > Well put Andrew. There is NO defensible<SP?> reason to peak at the next > serial value in application code. The practice is a recipe for disaster. > > Art S. Kagel Well sort of... Suppose you wanted to create an order entry where you knew the order number at the start of the order... (And yes, there are reasons for this...) But then again, I wouldn't recommend a serial number, but possibly a stored procedure or some code within the app to generate it. Like those 6 - 8 character strings used by reservation systems as locator codes.