>>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?
>
>select mytable
>cTagname="mytag"
>if empty(tagno(cTagname))
>=messagebox("Invalid Tag!")
>endif
Ed, for a one-time solution to a problem tagno() will work, but I would hesitate to add a function to my application when the HELP says it is included 'For compatibility with dBase'
Barbara