Is there a way to programmatically determine whether an index tag for a table exists?
I've got an app in production and we have an upgrade to the software, on that requires an existing table have an additional index added to it -- a regular index.
I have a startup routine that already checks to make sure needed tables are where they should be so I was thinking of modifying the startup routine so it checks to see if the index tag for the table in question already exists in the table's CDX. If not, then I'll create it programmatically, otherwise, do nothing. I can't find a FoxPro function that already does something like that.
Any or suggestions ideas?
Ernie Veniegas
Micro System Solutions
... sensible software by design