Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid key lenght
Message
From
03/02/1999 14:30:12
Jean Gagné
Bergeron & Trudel Inc.
St-Albert, Quebec, Canada
 
 
To
03/02/1999 13:13:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00183440
Message ID:
00183568
Views:
21
Hi Doug

>>If I reduce the field lenght to 120 it works fine. 121 doesn't work.
>
>You've got the default collate sequence set to something other than "MACHINE". For other collate sequences, VFP stores 2 bytes per key characters, so the maximum length of a key is 120 characters for non-machine indexes (since 2 * 120 = 240, which is the VFP maximum).
>

Collate was set to GENERAL. I changed it to MACHINE and it works just fine.

Thanks !

Johnny
Johnny
Previous
Reply
Map
View

Click here to load this message in the networking platform