Kbase P8005: Which VST Tables hold the Table Names and Table Fields?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2008 |
|
Status: Verified
GOAL:
Which VST Tables hold the Table Names and Table Fields?
GOAL:
Where are the Table Names and Table Fields?
GOAL:
How to generate a list of Table and Field names programmatically
GOAL:
How to create a list of Table names and Field names programmatically
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
The Table Names and Table fields are held in Virtual System Tables (VST):
Table Names in _file
Table fields in _field
The following is an example of how these could be extracted:
/* Table Names and Table fields */
OUTPUT TO Table.file
/* _file-number > 0, excludes Virtual System Tables,
_file-name BEGINS "SYS" excludes system tables from the listing */
FOR EACH _file WHERE _file-number > 0 AND
NOT _file-name BEGINS "SYS":
FOR EACH _field OF _file:
DISPLAY _file._file-name _field._field-name.
END.
END.
OUTPUT CLOSE.
/* END OF */