>Has anyone seen the error "Invalid key length" when doing a simple select statement from 2 tables. I am sure it is something with one of the data files because the same Identical version of software is running on several different machines without error. I have searched for and come up empty with a solutions
>
>foxpro version 2.6a
>
I've seen this with very large fields used in a WHERE clause; FPW tried to build a temporary index on the field that exceeded the maximum length on an index (240 characters or 100 characters depending on whether a compact or non-compact index is used). If the field involved is <240 characters, building a compact index on the field for all tables in advance may avoid the problem.