Gene Wirchenko wrote:
I have many browses that I would like to have row-level
validation for. I am trying to solve the validation problem in general.
The most important case is the work transaction table. It gets
data from DE and from importing from other systems used by the
company. All of this has to agree. Before invoicing, there is a step
we call "editing" where the data is checked for consistency. This
requires 1) being able to look at many rows at once and 2) being able
to edit the data. I want full validation in there.
One of the row-level validation rules required is that
basicchg+ovrhdefee=dsbamt+xsvamt
(Those are four columns of the table.)
Ok, so these 4 columns have to pass this rule. Simple enough having a
form method to do some checking and you can then colour the row if it
does not match this rule. The user then knows it has an error and can
fix it. From what you have said so far it appears you want to do the
validation using the valid event for each column. I'm not sure that
will work. E.g. If you start off with this data:
basicchg ovrhdefee dsbamt xsvamt
4 2 3 4
If your basicchg field has the focus the row does not pass the test so
your valid clause will not let you move off the basicchg field. What if
the 4 is correct and I want to change xsvamt to be 3, which will make it
pass the rule. You could change any one of them to make it pass the
rule, so IMHO you have to put the validation at form level.
Peter
----------------------------------------------------------------
Rajan Imports has changed - we are now Whispering Smith Ltd. For more
information see our website at www.whisperingsmith.com
Please update your address book with my new email address:
[email protected]
.
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or
disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700
Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
