What are the limitations of a FoxPro Full-ISAM file?

The FoxPro Full-ISAM driver implements FoxPro version 2.6 files and the following are FoxPro limitations. Non-FoxPro Full-ISAM drivers have different limit values.

    Maximum length of a field name: 10 characters
    Maximum number of fields per record: 255
    Maximum length of a character field: 32767 characters
    Maximum number of directories: 47
    Number of decimal places in numeric fields is required.
    Record name parameter is ignored.
    Binary fields are not definable in BASIC.
    Key part allowable options are:
    Uppercase (for string fields)
    Number of decimals (for numeric fields)
    Directory allowable options are:
    Descending sequence
    Ascending sequence


Please refer to the "Full-ISAM file" documentation available from our Download Center on our Web Site.