At 14:05 2013-04-24, "Kurt Wendt" <[email protected]> wrote:
Gene - at one point you wrote:
> To edit, the operator needs to be able to see many transactions
> at once. Currently, the system uses grids and does not have much
> error checking.
Did you mean to say the system uses BROWSES w/o much Err Chking?
Yes, that's right. Or wrong. (Depends on what "that" is.) I
meant "browses".
> If I use grids instead, I want full error checking.
By the way - do you really need to let them have access to ALL the data
fields in the Grid - since you could make some columns Read Only - then the
others aren't - and they can Edit & U can validate.
Yes, I do. Any of the data might be wrong and should be correctable.
Even Client Code could be wrong. We sometimes have some sister
client companies (similar ownership and sometimes in a related
business area) where we have to take special care in editing to make
sure that the right company is charged.
> As I see it, I would
> still have to duplicate my validation.
Not sure I understand why Validations would be Duplicated - unless you're
validating from several locations. But, in that case - just call a Method
that does the Validation - and call the same Method from multiple locations.
I am of the school that there should be validation at both the
front-end and the backend. The backend validation protects the
database. The front-end validation is for ease of use. As I see,
both are important. Passing everything to the back end for
validation is so mainframe, I mean, Web form.
> 3) Validation is using .valid(). I would like to change this to
> .LostFocus(). What are the ins and outs?
If you use the Valid Method - and they did something wrong & validation
failed - they stay ON The field. But, if you use LostFocus - now you have to
PUSH The control BACK to the field being validated - or something like
that...
There is another factor. If one has certain events on the
execution stack, one can not use SetFocus. That will throw an error
2012 ("Cannot call SetFocus from within a When, Valid, RangeHigh or
RangeLow event.")
If I want to have a form inside of another form's validation
and set focus in the second form, I can not do so. Apparently, using
LostFocus is a solution for this. I experimented a bit but then had
to do something else.
Sincerely,
Gene Wirchenko
_______________________________________________
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/
** 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.
