Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find Index key

Status
Not open for further replies.

joellister

Programmer
Joined
Jul 13, 2008
Messages
2
Location
GB
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.

 
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
 
Hi Jock,

Thats done the trick.

Many thanks for you help.

Joel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top