Re: Where best to validate multi-row block

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1090848882.443194_at_yasure...
| Roy Munson wrote:
| > Hi Guys....neither of these solutions works as the data has not been
| > posted to the database.
|
| The database is irrelevant. Validate in the blocks.
|
| --
| Daniel A. Morgan
| University of Washington
| damorgan_at_x.washington.edu
| (replace 'x' with 'u' to respond)
|

only if just the data in the blocks are of interest ... which is probably the OP's focus

but it appears that the OP wants to use SQL to validate sets of detail records... this can be done in the POST-FORMS-COMMIT trigger (which i forgot about in my earlier post)

also, what i don't think anybody has mentioned is that a calculated field (going by memory, don't remember the exact Forms terminology) could be used to provide summary data from the detail records, and that can be used at any time to validate detail-vs-master data

but if there's any possibility that some other detail records exist only in the database and are not present in the detail block, then issuing an explicit POST before validating, or doing validation in the POST-FORMS-COMMIT trigger is the way to go

++ mcs Received on Mon Jul 26 2004 - 16:42:34 CEST