Re: Newbie: Primary key assignment

The first will be more efficient and has the advantage it will also work in sqlplus and other tools.

Both triggers will fire. The pre-insert trigger will fire first, the database trigger last.

Hth,

Sybrand Bakker, Oracle DBA

S. van Hoof <info_at_hoof.nl> wrote in message news:881ibo$h8q$1_at_news1.xs4all.nl...
> I am using Forms 5 and Oracle7.
>
> I wonder where I should handle the "primary key" assignment for my tables,
> in the server (database insert row trigger) OR in my forms (pre-insert
> trigger) ?
>
> What happens when both triggers exist?
>
> Thanks
> Stephan
>
>
>
>
>
Received on Fri Feb 11 2000 - 12:22:57 CST