Enforce field values to be populated in the database

SYMPTOMS

The ZySCANservice does not apply the option input required set on database fields field when running as a service. It may create empty records in the database because Allow Nulls is set to Yes. (by default it is set to Yes). ZySCAN only inserts during export (creates a record and sets the fields). If you run this in ZySCAN or when running ZySCAN as a service, the export fails if a field which is required and the Table column dbo is set not to Allow Nulls in the database with the following error: "Cannot insert the value NULL into column 'fieldname' table 'databasename.dbo.databasename'; column does not allow nulls. Insert Fails." The job will not be exported

CAUSE

The ZySCAN Service does not restrict fields to be populated.

RESOLUTION

The best way to prevent ZySCAN exporting or creating empty records in the database is not to Allow Nulls in the design for one specific field which is set in ZySCAN as input required.

APPLIES TO

6.3