Obtain info about index FOR() use 1

[Prospector]

Members:

This explantion may be a bit fuzzy, and you should feel free to add erudite clarification.

I want to retrieve in a "usable" format all the info about any index including any use of the FOR()statement.

I am working with an inherited, existing system which has no documentation. It appears as though the indices were originally constructed with the FOR(), but I do not know how to verify that.

What do you think?

Prospector

 

[DSummZZZ]

Well, I've always used DISPLAY STATUS to verify index tags, but here is a quick little routine you can use also:

FOR zzz = 1 TO tagcount()
?'Tag: ' + TAG(zzz)
??' Key: ' + KEY(zzz)
??IIF(DESCENDING(zzz), ' Descending', '')
??IIF (!EMPTY(FOR(zzz)), ' Expression: ' + FOR(zzz), '')
NEXT

?CDX(1) gives the name of the index file used in work area 1.

There are probably other functions you can utilize also, but these are the most common.

Dave S.