FoxPro tables limitations

There are some limitations of FoxPro® tables:

The only limit which ever impaired our programs was the maximum of 255 fields per record. It happened when transferring data from SQL tables of IT sytems to FoxPro® or in the opposite direction. Our soultion was, to setup a main table including all fields used for an index and keep additional fields in parallel tables. (e.g for each record in the the table customer.dbf exists a record in the table customer_01.dbf and customer_02.dbf) When transferring data, a glossary was build referring to which field is where. Since you can open these 3 tables from the examples simultaneously and add a little routine which takes care to move the record pointer in all 3, it is easy to overcome this limitation.