Simon,

Do the UNIQUE(), PRIMARY(), CANDIDATE() etc functions not do what you want?

UNIQUE() is not properly documented in the VFP7 Help, but Hacker's has a write-up on it that is useful.

cheers


>Hi
>
>I ran into a problem where I needed to know if an index was created using the Unique clause. However, I could not find any function that would return this info.
>
>Other than routing the Display Status to a text file and searching the results does anyone know how to determine this programmatically?
>
>Ideally it would be good to have a function that returned the index type (ie. Primary, Candidate, Unique).
>
>Thanks
>Simon