Data Validation

You are here: Using Database Tools > DBMS > Working with Tables > Data Validation

Data Validation

Server-side data validation is performed when adding new records or updating existing tables. That validation includes NULL checking and numeric validation:

For NULL validation, an error is reported if a column that is not nullable is left empty.

For numeric fields, an error is reported if inputs are not numeric.

For other errors, an ODBC error description is returned.