Re: Unique rec. ID advice needed

In <317511F8.1B3_at_Pophost.eunet.be>, Jan VAN HYFTE <Jan.VANHYFTE_at_Pophost.eunet.be> writes:
>Using a Sequence is OK, but you can't have it automaticly defaulted on
>creation. When defining Oracle Tables, you can define default values for
>each column, but unfortunatly, you can't use SEQUENCE.Nextval as a
>default value !!!
>
>Jan VAN HYFTE

Yes you can have it automatically defaulted by using a Database Before Insert Trigger to set the column value to seq.NEXTVAL. We do it for contract id's, transaction id's etc.

D. Scott Moyer, Jr.                        dmoyer_at_gpu.com (work)
GPU Service Corporation                dsmoyer_at_enter.net (home)