Re: Refreshing Data In POST-DATABASE-COMMIT

<elie.constantine_at_gmail.com> wrote in message news:1107442584.707841.76110_at_l41g2000cwc.googlegroups.com...
> Hi
>
> 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
>

you may be able to set an indicator (in a package varaible) and then check it in a WHEN-NEW-RECORD-INSTANCE trigger, which should allow you to requery the child block(s)

++ mcs Received on Thu Feb 03 2005 - 16:02:49 CET