Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange Invalid key length (Error 112) message
Message
From
30/05/2001 07:10:09
 
 
To
29/05/2001 22:58:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00512427
Message ID:
00512574
Views:
13
>I seem to recall that if SET COLLATE is anything other than MACHINE, maximum key length is 120 instead of 240.

Exactly!!!

I had a SET COLLATE TO "GENERAL" because of portuguese acented names in another table, without a "closing" SET COLLATE TO "MACHINE", but, anyway, I wasn't aware of this key length issue.

After reading your helpful reply I went back again to error 112, INDEX ON and SET COLLATE explanations and found no reference to what you told me. Please, where can I find a reference to this in VFP docs?

Thank you very much, All.

Best regards,

Fernando
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform