Re: Forms 4.5 Commit Validation

From: <psalmu_at_my-dejanews.com>
Date: Mon, 11 Jan 1999 11:55:05 GMT
Message-ID: <77coqp$cff$1_at_nnrp1.dejanews.com>


In article <77dv7j$7pe3_at_indo-news>,
  "Idwi" <idwi_at_softhome.net> wrote:
> 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 ?
I would use post-forms-commit trigger where you can read the data from the database before it is actually committed.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 11 1999 - 12:55:05 CET

Original text of this message