Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid key length question
Message
From
28/11/2001 11:25:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00587001
Message ID:
00587015
Views:
32
>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,
What's syntax you used to create index ? No alltrim() ?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform