Re: OO40 using ADDNEW on a Table with a Sequence.

The Trigger is on Insertion. All it does is supply the primary key with a number from a sequence. On the Dynaset, when I do an UPDATE OO40 returns an error message saying the primary key is NULL. The key should be filled when the insertion takes place.

Kevin P. Fleming <kfleming_at_access-laserpress.com> wrote in article <35479D42.1B6DCCE_at_access-laserpress.com>...
> There's no way that the client application could do anything to affect
> the execution of the trigger, unless the trigger is using a WHEN
> condition to control its firing. If you've got the trigger defined to
> only fire when certain columns are NULL, it's possible the client app is
> supplying a value for that column and disabling the trigger.
>
> Wade Beasley wrote:
> >
> > I am trying to issue an ADDNEW via a Dynaset against a table that has a
> > insert trigger utilizing a sequence to generate a unique key. My
problem
> > is the key is not being generated. Any one have any suggestions?????
> > --
> > Wade Beasley
> > ext9jxb_at_air.ups.com
>
Received on Thu Apr 30 1998 - 16:16:30 CEST