Kbase P104693: In the 4GL, can a temporary index be created then deleted for a database table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/05/2005 |
|
Status: Unverified
GOAL:
In the 4GL, can a temporary index be created then deleted for a database table?
FIX:
It is not possible to create a temporary index against a database table in the 4GL. Indexes are part of the database and need to be created via the Data Dictionary tool. An alternative way to accomplish this is to define a temp-table which has the fields and indexes defined that you need then populate the temp-table from the database table.