Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot index field = 240 characters
Message
De
27/09/1999 16:09:19
 
 
À
21/09/1999 11:29:16
Pierre Richard
Méthotech Canada Limitée
Kirkland, Québec, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00267139
Message ID:
00269611
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform