Kbase P128230: 4GL/ABL: What is the relationship between the _File and the _Field tables?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/16/2009 |
|
Status: Verified
GOAL:
4GL/ABL: What is the relationship between the _File and the _Field tables?
GOAL:
What is the relationship between the _File and the _Index tables?
GOAL:
Is there a common field relating the _File with the _Index or the _Field tables?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
No, there is no common field that ties the _File table with either the _Field or the _Index tables. The relationship between the _File and the _Field tables is based on the the equality between the _Field._File-Recid field and the RECID of the _File record. For example, the following FOR EACH block lists all user data table names and their field names:
FOR EACH _File NO-LOCK WHERE _TBL-Type = "T",
EACH _Field NO-LOCK WHERE _Field._File-Recid = RECID(_File):
DISPLAY _File-name _Field-name.
END.
Similarly, the relationship between the _File and the _Index tables is based on the equality between the _Index._File-Recid field and the RECID of the _File record. For example, the following FOR EACH block lists all user data table names and their INDEX names:
FOR EACH _File NO-LOCK WHERE _TBL-Type = "T",
EACH _Field NO-LOCK WHERE _Index._File-Recid = RECID(_File):
DISPLAY _File-name _Index-name.
END.