Gene Wirchenko wrote:
Aren't you contradicting yourself when you state "check every time they enter a value"? If I check every time, then it will throw an error if I change one of the values. Correcting an error might involve more than one of the controls. That is why the validation is row-level; it does not make sense at the individual control level.
What I mean by check a value every time is having a form level function (say called rowcheck ) and for every column that needs checking put in the lostfocus rowcheck(). In this function you do the checking and mark a field (say logical field lValid) in your cursor as .T. or .F. At any time you will then know if the row is valid or not and that will allow you to decide if they can change row. Not sure what you mean by "Throw an error" but the row is either valid or it is not and there is no point doing anything until they have corrected it (which may involve changing more than one value, so you won't know when they have finished editing until it passes the validation).


My problem is getting the current values of the controls. Other than that, my code works. Unfortunately, not having the current values of the controls makes a mockery of validation and is a show-stopper.

Not sure what you mean by current values of the controls. The values in the underlying cursor are what matter to me and the validate function can check them.

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.

Reply via email to