Re: Sequences Still won't work

you must use PRE-INSERT at the Block level. for your sequence !!!

To be better make an additional BEFORE INSERT on your table trigger on the server side.. and test if New.yourPK is NULL, if yes..then set the New.YourPK with your sequence..

Olivier Régis
MCSE+I, Oracle CP
Switzerland

Denny Dutcavich <dut_at_mindspring.com> wrote in message news:3820FC0E.33384F2E_at_mindspring.com...
> I am getting very frustrated here (but a lot smarter as well). I created
> a
> INSERT trigger against the a table using procedure builder. It updates
> the PK with the next sequence.
> I tested it using plain old SQL INSERT commands in SQL*Plus and it
> worked very well. Now, when
> I try to use it in the form, I get a message from Forms saying the
> record is
> already inserted. I tried creating an ON-INSERT trigger against the
> block and
> I get the same message indicating the record was already inserted. I
> have
> put the edit control on the form, I left it off the form and I have
> hidden
> it - none worked. Is there some property for this object that I am over
> looking. This must be a simple process??? Thanks for any help...
>
Received on Thu Nov 04 1999 - 17:33:24 CET