Deleting the index won't solve your problem. The reason it can't find the long field name is because that field has been renamed to be shorter. If you want to have a table be free at some point, you need to use short field names.

Michelle


>I'm trying to create a routine that frees up a table from a DBC programmatically.
>
>Using VFP 6, I issue a "FREE TABLE mytable". This works.
>
>The problem I'm having is that "mytable" has long field names and one index tag that is based on a long field name. The first time I "USE mytable", I get error "Variable 'mylongfieldname' is not found.".
>
>How can I suppress this error message from showing? Or how can I delete the tag(s) and re-create them without user intervention?
>
>Thanks,
>
>Jerryt