Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Big speed issues when making the jump to 9.0
Message
From
10/05/2005 13:15:01
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01012291
Message ID:
01012496
Views:
22
>sergey
>can you explain what is correct way to fix this problem.

OK, I will tell you the better way to do it. I told you how to find out which tables have the wrong codepage, namely by using them one by one, and comparing the CPDBF() value to the CPCURRENT() value. For all the tables which have the wrong value, you
1. USE yourtable EXCLUSIVE
2. COPY TO TEMP
3. ZAP
4. DO CPZERO WITH "yourtable"
5. USE yourtable EXCLUSIVE
6. Choose the correct codepage
7. APPEND FROM TEMP

And, to be on the safe side, make a backup BEFORE you start the process!
Previous
Reply
Map
View

Click here to load this message in the networking platform