Re: Triggers not always work???

Jack Parker (jparker@boi.hp.com) wrote: : 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. : cheers : j. Jack, Do you have any capability to log the trigger activity off to a flat-file? Are you sure the trigger's firing? Maybe it's firing and then getting rolled back for some reason. I've never known them to fail. Joe : _____________________________________________________________________________ : 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. : _____________________________________________________________________________ -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------