Re: Triggers not always work???

> > Jack, > > Your understanding of the way it should work is correct. Sounds like > you found a bug or an undocumented feature. Would be interested in > hearing if you get this resolved with Informix. > > In article <4pi0ok$l92@hpbs2500.boi.hp.com> you write: > > > >Online 7.11. > > > >For some reason triggers are not always getting invoked by an esql/c update > >program. My understanding was that there was no way around the trigger - it > >resided at an engine level and ANY update to the table would invoke the trigger. > >This is apparently not the case. Thoughts? There IS an update and insert > >trigger, and they work fine from all other places. The esql/c program may > >have been compiled under an older version of the engine. > > Turns out that there are other issues involved in the triggers 'not working'. Jonathan gave us a good hint - telling us to stick a DEBUG in the invoked SPL and see what was going on. Not sure why that didn't occur to me... In other words the triggers work fine, the invoked SPL does not always do its job through data and pilot error. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________