Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error #112: Invalid key length.
Message
From
24/02/1998 11:02:59
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00080792
Message ID:
00080796
Views:
22
>What does this error message mean? I mean, other than 'An invalid index key length has been specified. The length of a key for an .IDX index must be between 1 and 100 characters. The length of a key for a .CDX index must be between 1 and 254 characters.' VFP 3.0b help file.
>
>I got this message when I tried to add an index to a table in a dbc. The index I tried to add was named 'JobName', the type was 'Regular' and the expression was 'JobName(cJob_Id)' where JobName is a procedure defined in the dbc's Stored Procedures. It returns the character name field from the Job table for the record id passed to it.
>
>This table also has 8 other indexes. Six of those indexes are on secondary key fields that are 6 characters in length. One index is DELETED() and the last index contains a procedure similar to the index that I'm trying to define.
>
>Am I placing too much of a burden on the .CDX file of this table?

If you really should have index on some calculated result (for Rushmore?) then it's probably that you could maintain one more field in your table and index on this field. I've never used index on function return value.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform