INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!

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

Jobs

Find Index key

Find Index key

(OP)
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

 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

RE: Find Index key

(OP)
Hi Jock,

Thats done the trick.

Many thanks for you help.

Joel

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!

Resources

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