>>>>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 ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only