Trigger: Simulating AutoCounter of MSAccess (Newbie)

From: ich <harald.gogger_at_de.bosch.com>
Date: Wed, 20 Feb 2002 09:58:19 +0100
Message-ID: <a4vodk$nr8$1@ns1.fe.internet.bosch.com>

Hi there!

I want to create a trigger, that fills the Primary-Key-Field of my table with an autmatically ascendending number (realizing with a sewuence).

Creating the sequence was no problem.
But now I don't know, how create the trigger.

Such as

---

create or replace trigger PMST27.T_Betreuer_AW_Trig after insert on T_Betreuer for each row
begin
insert into PMST27.T_Betreuer (BetreuerNr,Abteilung,Name,Telefon, Telefax) values
(T_Betreuer_seq.nextval,:new.Abteilung,:new.Name,:new.Telefon,:new.Telefax); end;

---

or

---

CREATE or replace TRIGGER PMST27.T_Betreuer_AW_Trig before insert on PMST27.T_Betreuer for each row
begin
:new.Betreuernr:=T_Betreuer_seq.nextval; end;

---

doesn't function

Thanks for help!

cu,
H. Gogger Received on Wed Feb 20 2002 - 02:58:19 CST