Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CodePage vs Collate vs Foxpro 2.5 and Visual Foxpro 5
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00273024
Message ID:
00274149
Views:
43
>Hi José,
>
>Thanks for the reply.
>I can see that you are familiar with the problem.
>
>With Foxpro 2.5b it does not want to let me Collate to "General".
>Config.fp contain CODEPAGE=AUTO
>But if I try SET COLLATE TO "GENERAL" I got the error "Collating sequence 'General' not found" although it is a valid option mentionned in the Help.
>
>So I took a chance and changed the involved index (Part.nom) with VFP5.
>I can see with VFP5 that the sorting is now ok.
>
>So it worked but... when I went back to DOS, I just cannot open the modified file.
>The command "USE PART" gives the error "File not Open".
>
>Why is that?
>
>Also, do I have to change the CODEPAGE also...in the file?
>
>Thanks in advance.

Rob is right in his answer. I'll simply add that if memory serves, we got a more decent support of collating sequences in 2.5c. In order to have it work in 2.5 you need the file FOXPRO.INT somewhere along your path. It should be (by installation) in the FP root.

José
Previous
Reply
Map
View

Click here to load this message in the networking platform