Re: SEQUENCE

From: <aldenhoven_at_my-dejanews.com>
Date: Wed, 17 Jun 1998 14:19:21 GMT
Message-ID: <6m8j99$bv1$1@nnrp1.dejanews.com>

Hi,

the way we do this is by createing a before insert trigger. So you can set another default e.g. -99 (a value that wouldnt appear in your column). Now you can programm your trigger that relpaces the old.value by new.value.

I dont know another solution

Hope I could help

Axel

In article <6m856c$o11$1_at_nnrp1.dejanews.com>, vjoshi_at_pinnacle.co.uk wrote:
>
> Is there a way of including the next sequence number as a default value within
> create table statement ?
>
> Many thanks in advance
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 17 1998 - 09:19:21 CDT