Alarm Biller does not have as strict of a requirement as Sedona Office when it comes to fields required not to have null, but there are some fields in each table that can cause issue. Due to this you may need to update a field to stop errors. The fields and their “null values” are listed below.
- Integers – 1
- Date – 1900-01-01 00:00:00.000
- Varchar – N/A
The scripts to insert these into the proper field will be.
Update [TableName]
Set [FieldName] = 1
where [FieldName] is null
Update [TableName]
Set [FieldName] = ‘1900-01-01 00:00:00.000'
where [FieldName] is null
Update [TableName]
Set [FieldName] = 'N/A'
where [FieldName] is null
