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

Can you post the code for the trigger, and the code you're using to do the record insertion? (Or email me directly if you like).

Wade Beasley wrote:
>
> 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 - 19:52:10 CEST