Re: HELP: How to generate sequential Primary Keys on a maste

Having done some work for a bank I can assure you that the solution is ridiculously simple. Every sequence number is inserted. No exceptions. The record itself ... however ... may then either be completed or marked as, like Tom with his checkbook ... void.

This solution is satisfactory under any audit rules.

Daniel Morgan

Philip Chee wrote:

> In article <a8q58d077a_at_drn.newsguy.com> tkyte_at_oracle.com writes:
> >In article <1018179580.6010snx_at_aleytys.pc.my>, philip_at_aleytys.pc.my says...
>
> >they are doing it exactly the way I describe!
> >I said:
>
> >Heck, just issue "update invoice_table set invoice_number = rownum" when they
> >walk in the door if you like. (thats the other sequential table you refer to)
>
> >Using something else as the primary key of course (the invoice_id column is for
> >the auditor who doesn't have a clue about computer systems, the primary key is
> >for us). (thats the SEQUENCE)
>
> Argh. <Re-reads thread from the begining>.
> Note to self: Don't post to usenet at 3 am local time!
>
> Philip
>
> ---=====================================================================---
> Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA
> e-mail: philip_at_aleytys.pc.my Voice:+60.5.291.1011 Fax:+60.5.291.9932
> Guard us from the she-wolf and the wolf, and guard us from the thief,
> oh Night, and so be good for us to pass.
> --
> þ 20415.09 þ Hello, I am part number ³ºÞº³º³Û³ºÝ³ºÝ³³
Received on Sun Apr 07 2002 - 16:31:37 CEST