Kbase P26370: Error 74 after adding a new record in a browser (can be a SmartDataBrowser)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error after adding a new record in a browser
Value <value> cannot be displayed using <format>. (74)
Value 12/31/-4714 cannot be displayed using 99/99/99. (74)
Date fields have a null default value (displays as blank).
Browser can be a SmartDataBrowser
CAUSE:
Bug# 20020723-002
CAUSE:
This is a known issue. When a record is created in a browser, if a date field has a null default value (?) and it is not updated by the user during data entry, then the underlying database field will be assigned a value of Dec 31st 4714 BC, which is our Day 0, instead of the null value.
FIX:
At the moment this problem can only be worked around, for example by actually assigning an initial value to date fields in the table, or by writing code that fires when the record is written to the database and changes any date field with value 12/31/-4714 to null (?).