Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid key length error message
Message
De
06/08/1996 17:07:59
Sonny Chouinard
CHCA Computer Systems Inc.
Lachenaie, Québec, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00005117
Message ID:
00005141
Vues:
24
>>>>I'm having trouble creating a key expression that
>>>>contains more than 100 characters (exactly 150).
>>>>According to the Help Message, I can create an index
>>>>expression up to 254 characters in a .CDX index, but I
>>>>keep having this message anyway. Is there someone who
>>>>could help me ?
>>>
>>>The max length is actually 240, according to MS KB doc. That seems to be right when I tested it - at 241 I got an error, but 240 was ok.
>>
>>Could you describe me your test. I tested it by creating
>>a file with a field of type char and length 150, then
>>I tried to create an index on that field and it didn't work.
>>Is there something that I do wrong ?
>
>Hmmm. I just chose a variable at random in a table and created a dummy index expression of length 240. But I also just tried your method with a char (150) and added an index without trouble. This is a regular index. Did you try a test table (no DBC) with one field only, see if that works?

Yes I did. I created a DBF file name test with just one
field called test1 of type CHAR and of length 150, then
I issue the following command :
index on test1 tag xxx
and I received this damned message. I tested it a further
more to notice that the maximum length of a key expression
that is allowed is 120. Is there a special setting that I
should do ?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform