Re: Autonumber field
From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Tue, 15 Jun 1999 18:52:36 GMT
Message-ID: <3766A12D.AA9F567E_at_lds.com>
Date: Tue, 15 Jun 1999 18:52:36 GMT
Message-ID: <3766A12D.AA9F567E_at_lds.com>
Build a "before or after insert trigger on row " on the table. Inside the trigger call a sequence then populate the column with the sequence.nextval. If U need to know what the value was after the insert call sequence.currval right after the insert statement.
Equiva Trading IT wrote:
> How do I create a field that automatically increments by one each time a
> record is added?
>
> Something similar to the MSAccess autonumber datatype.
>
> Thanks,
> Kurt
-- =============================================== Marc Weinstock Logical design Solutions 55 Broadway - 21st Floor New York, New York 10006 Phone: 800.221.5327 x2136 Fax: 212-825-2245 E-Mail: MWeinstock_at_lds.com Web: http://www.lds.comReceived on Tue Jun 15 1999 - 20:52:36 CEST