Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid key lenght
Message
From
03/02/1999 10:48:00
 
 
To
03/02/1999 10:37:05
Jean Gagné
Bergeron & Trudel Inc.
St-Albert, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00183440
Message ID:
00183453
Views:
16
Hi Johnny ---

What is your SET COLLATE setting? Also, what is your Code Page setting for the table. I have a feeling that codepage translation is getting in the way and that maybe the 240 char limit is based on a binary limit and not a character-by-character limit.


>
>The VFP 5 documentation says that a CDX index key can be up to 240
>characters long. When I issue the following commands I get an error 112
>- Invalid key lenght.
>
>create table x (x c(240))
>index on x tag x
>
>If I reduce the field lenght to 120 it works fine. 121 doesn't work.
>
>What could be wrong. Is there a parameter that I should change in VFP. I
>am using 5.0 (build 415), french version.
>
>Thanks !
>
>Johnny
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform