Re: How get the current value from a sequence?

Ubiquitous wrote:

> AK <ak_tiredofspam_at_yahoo.com> wrote:
>
> :> > I don't want to gaps in the sequence.
> :>
> :> Then use a method that serializes on a table.
> :> Sequences guarantee uniqueness not completeness.
> :
> : I'd concur. For instance, Oracle comes with built in message queueing,
> : which comes very handy when you don't want gaps.
> :
> : But what is wrong with having gaps in your situation?
>
> One word. Auditors.

Auditors should not care. If they do then one of two situations exist.

1. They are incompetent
2. Your system does not comply with Sarbanes-Oxley

(of course assuming you are in the US).

Consecutive numbers are not a requirement. Not being able to fake entries is.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)