ODBC: Table-level Validation Rules

An example of a validation rule for a column of data is not allowing the Salary column in an Employee table to be less than zero. If someone enters a value less than zero into the Salary column, the entry is rejected and a message box appears, telling the user what data is valid for this column.

VIP Workshop allows you to implement validation rules in forms - using a Validation rule property. VIP Workshop will also support any validation rules already established by an originating data source However, because those validation rules are set at the ODBC level, you will not be able to modify them. Contact the ODBC vendor for more information.