Re: Forms and triggers ---Help Needed Urgently

Probably your triggers are locking the record you are seeing in the forms application.

Joep Hendrix

mdesouza_at_YAHOO.COM wrote in message <77ni6b$7hu$1_at_nnrp1.dejanews.com>...
>Hi all
>
>I have got a nasty problem and I have been stuck on it for a few days
>
>I got a forms which update inserts data into a reference form
>
>the table has three triggers on it . before update , before insert , before
>delete which fires and stores audit log info about changes made to the
table
>
>
>the problem is that when I run the forms and change a field and then press
the
>save button it works fine if I change another field the form hangs
>
>why does it only work the first time ??
>
>If I disable the triggers its works fine ..
>
>the triggers call a procedure store audit .. do I need a commit in this
>procedure .. so is there somethin I missed out ..
>
>any help would be appreciated
>
>regards
>
>michael
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Jan 18 1999 - 10:05:34 CET