>Dear Experts
>
>index on mill+bank+branch to account22
>
>the above line work fine but the following line
>
>index on mill+bank+branch+account to account22
>
>display this error message
>Invalid Key Length
>
>How to get rid of this message?
Check the help for this error:
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.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.