>Hello !
>
>The VFP 5 documentation says that a CDX index key can be up to 240
>characters long. When I issue the following commands I get an error 112
>- Invalid key lenght.
>
>create table x (x c(240))
>index on x tag x
>
>If I reduce the field lenght to 120 it works fine. 121 doesn't work.
>
>What could be wrong. Is there a parameter that I should change in VFP. I
>am using 5.0 (build 415), french version.
>
>Thanks !
>
>Johnny
I don't know what is wrong, but realistically (for app purposes) it's probably enough to INDEX ON LEFT(x,10).
Edward Pikman
Independent Consultant