Oracle triggers not always firing

I'm having problems with Oracle triggers firing when using Powerbuilder.

I'm using Powerbuilder 7.03 and Oracle 8.1.7. I have 'before update on each row' triggers coded for an Oracle table. If I go to the PB database painter, isql tab, and code sql to update the table then the triggers fire as expected.

If I go to the database painter, click on the table in the 'objects' view, then click the 'Data Manipulation (grid) button and update data in the table the triggers do not fire, although the database table is updated.

Why would the triggers sometimes fire & sometimes not, even though the data in the table was updated? Any help would be greatly appreciated.

Lisa

ps - also posted to Powerbuilder newsgroups.

--

Lisa McGrath
Lmcgrath_at_uwsa.edu (608) 263-4535
Office of Information Services
University of Wisconsin System Administration
--
Received on Thu Jun 19 2003 - 17:15:39 CDT