Jerry,
Just another idea: create a temprorary DBC, add your table to it, do all modifications, then free this table.
>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
If it's not broken, fix it until it is.
My Blog