Kbase P124530: How can I find or display the table number of a database table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/24/2009 |
|
Status: Verified
GOAL:
How can I find or display the table number of a database table?
GOAL:
How can I find or display the schema defined table number of a database table?
FACT(s) (Environment):
All Supported Operating Systems
Progress 6.x
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
FIX:
To display the table names and numbers for a Progress database, use the following steps:
1. Connect to a OpenEdge database in single or multi-user mode.
example: pro <database>
mpro <database>
2. In the procedure editor, type in or cut and paste the following code:
for each _file:
display _file._file-name _file._file-number.
end.
Run the code by pressing the F1 key or CTRL-x.
The file or table name and number will be displayed as follows:
Example:
File-Name File-Number
-------------------------------- -----------
Benefits 15
BillTo 17
Bin 21
Customer 2
Department 14
Employee 10
Family 13
Feedback 9
InventoryTrans 22
Invoice 1
Item 3
LocalDefault 7
Order 18
OrderLine 4
POLine 24