Kbase P103331: How to identify determine an index by index number ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/15/2005 |
|
Status: Unverified
GOAL:
How can I determine an index name via the index number?
GOAL:
How to identify an index name by an index number?
FIX:
A number of Progress messages relating to index problems will report only the index number.
Often, one will want an easy way to determine which index (and which table) this actually applies to by looking up the index and table names.
This can be achieved using the following 4GL code:
DEFINE VARIABLE iIdxNum AS INTEGER NO-UNDO.
UPDATE iIdxNum.
FIND _index WHERE _idx-num = iIdxNum NO-LOCK NO-ERROR.
IF AVAILABLE _index THEN DO:
FOR EACH _file of _index:
DISPLAY _file-name _index-name.
END.
END.
ELSE
MESSAGE "Index Does Not Exist" VIEW-AS ALERT-BOX.