>Hi...am curious, in the VFP 7.0 table designer, there is a "Record validation" section for each table. Could someone give me an example when is this used?
>
>Wouldn't the Insert and Update triggers be used to validate a record?
>
>Doesn't the record validation section duplicate things that would normally appear in the field validations for each field?
>
>Is this just an example of TMTOWTDI or are there pros and cons?
>
>Thanks
The difference between field/record validation, on the one hand, and triggers, on the other, is when they are executed.
I prefer triggers, since field/record validation rules may be executed too early. With triggers, you control when the validation is done (basically, when you do TableUpdate()). As you can see, I use buffering.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)