Re: Losing sequence numbers

You are most likely losing numbers because your sequence is caching numbers. This is the default setting when you create a sequence (20 values are cached by default). To avoid this specify nocache as part of your create sequence script.

If the database is brought down for any reason, the cached values are lost. Another possibility is that the end users are getting a value from the sequence, but not issuing a commit on their form. In this case the sequence value is not returned back to the sequence, they are lost.

Don Received on Thu Jan 04 1996 - 00:00:00 CET