Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot index field = 240 characters
Message
From
27/09/1999 16:09:19
 
 
To
21/09/1999 11:29:16
Pierre Richard
Méthotech Canada Limitée
Kirkland, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00267139
Message ID:
00269611
Views:
15
Hi Pierre.

>I am trying to index a free table with a compound index, The single field index is 240 in length yet I get an "Invalid Key Length" error message.

The 240 character limit is only when you use MACHINE as the collate sequence. If you set it to anything else, each character in the key takes 2 characters in the index, so you effectively can only use a 120 character expression.

Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform