Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Find Index key

Find Index key

Find Index key

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.


RE: Find Index key

Hi, joellister


 Return the key expression of a specified index


     INDEXKEY(<nOrder>) --> cKeyExp


     <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.


     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 ("").


RE: Find Index key

Hi Jock,

Thats done the trick.

Many thanks for you help.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close