>I wanted something like best of both the worlds, fire quite early automatically and in my controllable postion, so the users can do the necessary and before being submitted, thus only clean data is tableupdated()
Well, with a separate validation function, based on data in tables, this would be possible.
If this is not feasible for you, well, and if you insist on using field-level and row-level validation, I really don't know - but perhaps you can create a function that extracts this information from the database.
>
>>
>>With table-based validation, you could check the rules before doing your TableUpdate(). As an additional security, you could call your validation function from the Insert and Update triggers.
dbgetprop("Field") and dbgetprop("Table") seem to be appropriate for this purpose.
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)