>>>I am trying to create a Regular index on 5 fields in a table and keep getting this error. In help it says the following about the error:
>>>
>>>

>>>Invalid key length (Error 112)
>>>Index keys must be between 1 and 240 characters.
>>>
>>>You created an index key of length 0.
>>>When Visual FoxPro creates an index, it evaluates fields in the first record in the table. Make sure that the first record of the fields you base the index on contains some data.
>>>
>>>You created an index key longer than 240 characters.
>>>Create a shorter index key.

>>>
>>>The 5 fields are all Character with the lengths of 8, 2, 30, 60, 80 = 180.
>>>Shouldn't this key be valid or am I missing something?
>>Colin,
>>What's syntax you used to create index ? No alltrim() ?
>>Cetin
>BTW collating sequence is machine ?
>Cetin

Hi Cetin,

Collating sequence is general. I am trying to create index in Indexes tab of table designer and, no ALLTRIM() not used.