Re: Trigger for auto-sequencing

From: stevieG <stevie-g_at_gmx.de>
Date: 2000/05/29
Message-ID: <8guafq$k5j$10$1@news.t-online.com>#1/1

Michel Cadot <micadot_at_netcourrier.com> schrieb in im Newsbeitrag: 8gu213$11kd$1_at_s2.feed.news.oleane.net...

hi michel,

when also accessing with oracle forms, I prefer this way:

 create or replace trigger bi_t
 before insert on t
 for each row
 begin

      if :new.id is null then
        select s.nextval into :new.id from dual;
      end if;

 end;
 /

I will give the id a sequenced value already in forms.

otherwise you will get a 'record has been updated or deleted by another user, please requery' exeption if you try to update the record after insert.

have fun
stevie Received on Mon May 29 2000 - 00:00:00 CDT