REPOST: Odp: Oracle WebDB sequence
From: Rodek <roderyk_old_at_poczta.onet.pl-nospam>
Date: Tue, 1 Jan 2002 16:55:02 +0100
Message-ID: <1$--$$-$-%$_$-___$_at_news.noc.cabal.int>
Date: Tue, 1 Jan 2002 16:55:02 +0100
Message-ID: <1$--$$-$-%$_$-___$_at_news.noc.cabal.int>
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
- WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Rodek" <roderyk_old_at_poczta.onet.pl-nospam> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.tools Subject: cmsg cancel <a0sm2k$h5a$1_at_news.onet.pl> Control: cancel <a0sm2k$h5a$1_at_news.onet.pl> Date: Wed, 2 Jan 2002 02:49:36 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.a0sm2k$h5a$1_at_news.onet.pl> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009948009 29203 166.102.15.34 (2 Jan 2002 05:06:49 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 05:06:49 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40286730
autocancel Received on Tue Jan 01 2002 - 16:55:02 CET