Re: Forms 4.5 Commit Validation

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Mon, 11 Jan 1999 08:23:00 -0500
Message-ID: <3699fb4c.0_at_news.mountain.net>

Use ON-COMMIT. But be aware this will replace the normal commit processing so you will have to code the commit statement in the trigger.

Kenny Gump
OCP 7.3 DBA

---

Idwi wrote in message <77dv7j$7pe3_at_indo-news>...
>Hi All,
>
>I got this problem, I have a master detail form, where there is a numeric
>field in master block containing amount that is entered by users. And then
>the users also enter the distribution of that amount in detail block.
Before
>committing, I want to check whether the sum of the distribution (in detail)
>is equal to the amount in master.
>I've tried using PRE-COMMIT trigger and using go_block command to go to
>detail block (to sum the amount) but Forms said it's a restricted
procedure,
>so I can't use it in PRE-COMMIT. What trigger that I can use instead of
>PRE-COMMIT ?
>
>Thanks for any reply.
>
>Regards,
>Ivan D.
>
>
>
>
>
>
Received on Mon Jan 11 1999 - 14:23:00 CET