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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Index tag expression

Status
Not open for further replies.

JimEkleberry

Programmer
Dec 25, 2001
150
US
Anyone know how to obtain an index tag's expression programatically?

Say I execute: INDEX ON fname + lname TAG fullname

I can use the TAG() function to obtain the index name of fullname but I need the fname + lname portion.
 
Check help for the sys(14)- index expression which should give you what you want. I use this in an array and let the user see which index (and expression) they want to use.

 
I just checked and it turns out that there is a KEY() function that does the same thing. Surprisingly, it isn't listed in any of the See Also tags or as a function.

I'll take a look at the SYS(14) function as well. Thanks for the help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top