Kbase P87793: How to programmatically add an INDEX to a database table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/10/2004 |
|
Status: Unverified
GOAL:
How to programmatically add an INDEX to a database table?
GOAL:
Can an index be added to a database table from the 4gl?
FACT(s) (Environment):
Windows
FIX:
All Progress Versions provide the source code for the Data Dictionary. Since the Data Dictionary is just executing 4gl, it is possible to create an index programmatically.
1. Extract DLC/src/adedict.pl using DLC/src/extractpl.bat.
2. Open DLC/src/adedict/idx/_newidx.p
You can determine how to create and Index programmatically by analyzing this source code.