Kbase P88105: Is it possible to set TIME as the initial value of an INTEGER field?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2009 |
|
Status: Verified
GOAL:
Is it possible to set TIME as the initial value of an INTEGER field?
GOAL:
Can the TIME function be used as an initial value of a field in the Data Dictionary?
GOAL:
How can the initial value of a database field be set to the TIME function?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
It is not possible to set the initial value of a field to the TIME function in the Data Dictionary.
An INTEGER field will not accept TIME as an entry as it interprets it literally as a non-numeric value.
A CHARACTER field will accept TIME as an entry but interprets it literally and not as a function. This makes the initial value of the field "TIME" rather than the value of the TIME function.
A workaround to this would be to assign the value of the TIME function to the field in a CREATE trigger on the database.