Refreshing Data In POST-DATABASE-COMMIT

From: <elie.constantine_at_gmail.com>
Date: 3 Feb 2005 06:56:24 -0800
Message-ID: <1107442584.707841.76110_at_l41g2000cwc.googlegroups.com>



Hi

[Quoted] I have 1 to many relation between 2 Data Blocks on a form.

When the user press the save button from the POST-DATABASE-COMMIT trigger I run a code that exists in a package in our oracle database.

This code checks for transactions in the child Data Block and delete every record that has Quantity = Zero. Everything is working good but I need to requery the child record once this operation is complete, but Oracle Forms give me a message telling me that I can't requery a datablock in this trigger: the POST-DATABASE-COMMIT.

What should I do?

Thanks Received on Thu Feb 03 2005 - 15:56:24 CET

Original text of this message