Odp: Oracle WebDB sequence
From: Rodek <roderyk_old_at_poczta.onet.pl-nospam>
Date: Tue, 1 Jan 2002 16:55:02 +0100
Message-ID: <a0sm2k$h5a$1_at_news.onet.pl>
Date: Tue, 1 Jan 2002 16:55:02 +0100
Message-ID: <a0sm2k$h5a$1_at_news.onet.pl>
Thank You very much, trigger was the right.
I wanted to put sequence in an identification number field, which must be
not null.
With "before insert" I didnt solve that problem. I took "after insert" and
I update table id field with sequence in trigger body. First I altered table
by inserting default 0 value of this field.
Can You write down how to do this with "befor insert" and dont use default
values in table?
THX
Rodek
Received on Tue Jan 01 2002 - 16:55:02 CET