Kbase P67902: Can not process SQL field with timstamp data type
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2004 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Can not process SQL field with timstamp data type
** <file-name>.<field-name> is mandatory, but has unknown (?) value. (110)
Error 110 received if the timestamp is not updated
When attempting to populate the timestamp field, receive cannot insert a
non-null value into a timestamp field error.
The timestamp field is defined as "not null" in SQL server
The timestamp field pulled into schema holder has mandatory attribute turned on
Problem not seen when "not null" constraint is taken off from timestamp field in SQL server and schema holder is rebuilt
CAUSE:
The timestamp field is automatically populated by SQL server, thus "not null" is not necessary. However, when "not null" is present in SQL server, dataserver pulls it in as mandatory field, thus error 110.
FIX:
Switch off mandatory attribute in Schema holder for the field