Where best to validate multi-row block
From: Roy Munson <mtproc_at_yahoo.co.uk>
Date: 22 Jul 2004 09:15:49 -0700
Message-ID: <853055e7.0407220815.619d6a16_at_posting.google.com>
Hi,
Date: 22 Jul 2004 09:15:49 -0700
Message-ID: <853055e7.0407220815.619d6a16_at_posting.google.com>
Hi,
[Quoted] [Quoted] Have a 2 block parent child form....the child block is multi row in which a number of pieces can be entered for each row.
A total value is entered in the parent block....am wanting to validate that the sum of the numbers entered in the child block does not exceed the value entered in the parent block.
Where is the best place to put the validation? PRE-INSERT is no good as data still not posted. POST-INSERT no good as its too late for validation to fail and rollback.
Any help appreciated
Roy Received on Thu Jul 22 2004 - 18:15:49 CEST