SedonaOffice in general does not allow any of its fields to have the value of null. However, not all fields are used by all customers. Due to this there are three “Null” Value defaults based on the data type of the field. If you receive an error of “Invalid use of Null” these will be the values you need once you find the errored field.
- Integers – 1
- Date – 1899-12-30 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] = '1899-12-30 00:00:00.000' where [FieldName] is null
Update [TableName] Set [FieldName] = 'N/A' where [FieldName] is null
