Re: Datatype Question

From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1996/12/09
Message-ID: <32ABF1DE.4BE5_at_adra.se>#1/1


Lam Sze Wai wrote:
>
> Can anyone kindly tell me whether there exists a datatype
> that when a new record is added, its value automatically
> is increased by one? How can I access it using Pro*C?

You might want to use a sequence to handle the number and a trigger to insert a new value each time you insert a row in the tabel.

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.
Received on Mon Dec 09 1996 - 00:00:00 CET

Original text of this message