I put my data validation in the database which may be VFP or Oracle or both. This makes the integrity of my data
front-end independent. Therefore, I no longer have to worry about a user, who has access rights, bypassing all the checks in a VFP app and hacking the data with MS Access and making changes.
Now that I do not have to write all that VFP validation code, development of a VFP app is so fast.
>Hello
>
>We all know that user can 'click' on any field, no matter tabindex property.
>
>Many times, we want to enforce field contents and field order before the user can click the 'save' button or the 'process' or 'report' button. In order to get this behaviour we have to put more code in valid (detecting lastkey()), when, lostfocus or gotfocus events.
>Also, some validations depends on values of previous fields.
>
>A very simple way to avoid all that code is: 'just put all validation code in the click event of the final button', before the save action or 'report form' command, etc. In this case, all fields are 'free' until last button is clicked.
>
>Which method do you work?
>
>
>Thanks,
>
>
>Juan Carlos.
Mark McCasland
Midlothian, TX USA