Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid key length question
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Invalid key length question
Divers
Thread ID:
00587001
Message ID:
00587001
Vues:
54
I am trying to create a Regular index on 5 fields in a table and keep getting this error. In help it says the following about the error:
Invalid key length (Error 112)
Index keys must be between 1 and 240 characters. 

You created an index key of length 0. 
When Visual FoxPro creates an index, it evaluates fields in the first record in the table. Make sure that the first record of the fields you base the index on contains some data.

You created an index key longer than 240 characters. 
Create a shorter index key.
The 5 fields are all Character with the lengths of 8, 2, 30, 60, 80 = 180.
Shouldn't this key be valid or am I missing something?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform