I don't use Forms, thanks for that extra information.
--
Cheers
Michel
stevieG <stevie-g_at_gmx.de> a écrit dans le message : 8guafq$k5j$10$1_at_news.t-online.com...
>
> 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 Tue May 30 2000 - 00:00:00 CDT
