Not Empty/Null Validation

If you select the Not Empty/Null field validation type, the Integrity page looks like this:

Not Empty/Null validation simply means that a field must have an entry. When a user edits the field or adds a new record to the table, view or CursorAdapter, the field cannot be left empty.

Not Empty/Null validation is useful for fields that donít lend themselves to precise validation rules but that should have an entry. For example, name fields in a customer or employee table donít normally comply with a set of rules that can be used for validation. However, name fields should not be left empty. Not Empty/Null validation works well for such fields.

ō To set up Not Empty/Null validation for a field

1.   Select Not Empty/Null validation on the Type combo box. Thereís no information to enter on the Integrity page.

2.   Click the Options combo box to turn on validation for the field. Choose the validation option that you want for the field.

3.   If you want to allow users to override an entry that fails validation, check the Override check box.

4.   Click the Level combo box to select when field validation should be run.

5.   When you leave the Integrity page for the field, VPM Enterprise will save your changes.


Referential Integrity