Find Index key

[joellister]

Can anyone tell me if there is a function to show what the key used to create an index file is?

I have dusted of my old version of Clipper S87 and cannot remember if there is function to do this. I know its possible in Visual Foxpro with the SYS(14) function. Is there an equivalent in Clipper?

Thanks for your help.

 

[JockMullin]

Hi, joellister

INDEXKEY()

Return the key expression of a specified index

Syntax

INDEXKEY(<nOrder>) --> cKeyExp

Arguments

<nOrder> is the ordinal position of the index in the list of index files opened by the last USE...INDEX or SET INDEX TO command for the current work area. A zero value specifies the controlling index, without regard to its actual position in the list.

Returns

INDEXKEY() returns the key expression of the specified index as a character string. If there is no corresponding index or if no database file is open, INDEXKEY() returns a null string ("").

Jock

 

[joellister]

Hi Jock,

Thats done the trick.

Many thanks for you help.

Joel