>>In the system capacities section of the VFP9 help file, it says that field names can be 128 characters in a database. It also talks about the file sizes of a table and an fpt. Is there any documentation on the length of an index name, or on the size of an index file?
>>
>>It appears that even though a field name can be up to 128 characters (I don't have any that long), the index name will still be pared down to 10 characters. Until now, I haven't had occasion to run into this issue, but now I have. Am I missing something, or is this just one of those undocumented cracks I'm going to have to work around.
>>
>>Thanks
>
>Check INDEX Command in Help:
>
>TAG TagName
>Specifies the name, or tag, for the index generated by eExpression and stored in a compound index (.cdx) file. Tag names must begin with a letter or an underscore (_) and can consist of any combination of up to 10 letters, digits, or underscore characters.

Yeah, that's real unfortunate. I pulled all the tables from a MS SQL database into vfp tables, and now I have a real problem with indices. Oh, well, lots of work ahead I guess. The other problem is that the primary keys are integer but unfortunately the designers of the system decided, for whatever reason not to create system generated ID's and instead used meaningful fields in the data for the keys, and that meant they required multiple fields for uniqueness. What a headache.