Thanks Ed --- that's what I needed to find ... It's funny, when I first got FPD 2.0 way back in '91, one of the very first things I did was to read the "Commands and Functions" manual from cover to cover. I knew, or at least had heard about, just about every command there was. Now, with VFP, that's a rather impossible task to try and accomplish. I tried to find a command to do this, I really did, but I guess I didn't try hard enough! So thanks mucho!
Bonnie
>>The question is: how can I tell what the index type is? If I can tell that the index in the table in question has already been changed to a regular index, I obviously will not apply the "fix" a second time. I have not been able to find a command that can tell me that ... anybody know if there is one? If not, any suggestions as to how I can tell the index type so that I don't have to re-index unncessarily?
>>
>
>You can use the CANDIDATE() function to check if the index in question is a candidate key (a primary key is just a special instance of a candidate key) or a regular key. You'll need to retrieve the Tag Number for the index in question, sinc the argument passed to the CANDIDATE function is a tag number not a tag name. You can use TAGNO() to retrieve the tag number for a given tag name.