Re: POST-UPDATE trigger on form or block

Post update does not commit, as it occurs after the update (in the forms/dev2k buffer cache), but before an explicit commit. What you want to do, should be done in a pre-update trigger.

Hth,

Sybrand Bakker, Oracle DBA

bdickey_at_my-dejanews.com wrote:

> I don't understand why a post-update trigger does not commit updates to the
> database. I assume this kind of trigger, attached to a block, is processed
> during the commit, because the changes appear correctly on the form after
> saving the record, but the database has not been updated. Where do you place
> a post-update trigger to make sure that the updates are committed? All I'm
> doing is checking to see if a field is null, then updating it with a value
> from another table. Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Mon Jan 04 1999 - 00:49:33 CST