Hi Hilmar,

Thank you for your answer. Glad to see that somebody does. I am groping for an easy way to implement this middle tier thing, where the business rule is neither in the form nor the database.

Add "FieldName" field to "Validation", "FieldValid()" to the DBC, and code to the UI classes (maybe to triggers too?) that calls FieldValid(), which performs field level validation based on the code in Validation.Rule.

Do you think that this is consistent with a proper 3-tier model?

Thank you.

Alex


>>The question is: Does anybody here use a table to store validation procedures?
>
>Yes, I do.
>
>In my database container, I have function RecordValid(). This function is called from each form in my application.
>
>Table validation has the following fields:
>

>Table (C)
>Order (I)
>Rule (M)  && Rule to be evaluated
>Spanish (M) && Error message in spanish
>Comments (M) && For the programmer
>Warning (L) && if .T., warning only. Record is still saved.