Re: How to increased by exactly 1 ?

Am 25 Jan 2005 03:44:11 -0800 schrieb adragnes <adragnes_email-usenet_at_yahoo.com>:

> In some European countries gap less sequences for such things as
> invoices is a legal requirement in accounting software for documents
> such as invoices. It was a way to make sure that no such documents have
> been destroyed. Oracle E-Business Suite does offer gap-less sequences,
> but their use is not recommend as performance really suffers.

Performance is ok with out approach.

> In databases I should think that the rationale behind the gap-less
> sequences can be achieved in other ways such as audit trails on the
> tables in question. Naïve reimplementation of paper-based procedures
> does not always make sense.

Agreed. But we simply could not convince them. Ever tried to convince people from financial departments?

> Even on paper pads with numbered sheets you could go wrong. You could
> for example spill coffee over them.
>

We told a similar example to our customer. Answer: "If such thing happens, you have to note it in a special book together with number, date (including time) and you have to sign it!" And so we implemented it. :-(

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)