What sould I do to having auto number??

From: Kanson Ku <u8422021_at_cc.nctu.edu.tw>
Date: Wed, 04 Aug 1999 01:33:36 +0800
Message-ID: <37A727F0.E32DF1A4_at_cc.nctu.edu.tw>

HI ALL
[Quoted] What should I do to have auto numbering without typing anything under FORM ??
1. Form trigger
2. DB trigger
How to write down the above trigger to get the auto numbering

My Form trigger:
(PRE-INSERT)
Select NVL(No,0)+1
into :Production.Sequence
From Sequence_number;

--but only with this
--The Form field don't fill the number automatically
--How can I write down the DB trigger to achieve the auto numbering???

Thanks in advance
Kanson Ku
u8422021_at_cc.nctu.edu.tw Received on Tue Aug 03 1999 - 19:33:36 CEST