Kbase P30840: How to get the Initial Value of a DB field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to get the Initial Value of a DB field
FIX:
To get the initial value of a field as it is set in the data dictionary then use the virtual system tables (or hidden tables). For example, in the sports2000 db there is a table, customer, with a field of country which has a initial value of "USA", to get this value the following code should illustrate the idea:
FOR EACH _file, EACH _field OF _file WHERE _file._file-name = "customer"
AND _field._field-name = "country".
DISPLAY _field._initial.
END.