Invalid key length (Error 112)

  • Article

  • If you created an index key that exceeds the following limits, create a shorter index key.

    The length of an index key for an index or compiled index (.idx) must be between 1 and 100 characters. The length for a compound index (.cdx) must between 1 and 240 characters.

    For certain collating sequences, or when using double-byte character sets (DBCS) characters, each character in the eExpression parameter in the INDEX command uses two characters in the index key. In these cases, the length of eExpression is limited to 120 characters.

  • If you created an index key with length of 0, make sure the first record of the fields you base the index on contains some data.

    When Visual FoxPro creates an index, it evaluates fields in the first record in the table.