Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Codepage of FPD 2.6 table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00188070
Message ID:
00188300
Views:
18
>Hello,
>I'm writing a conversion for FPD 2.6 tables into VFP 6.0.
>When I USE an old table and ALTER it, VFP will ask me:
>"File myTable.DBF is not marked with a Code Page.
>Please select the CodePage the table was created in."
>Can I automatize this selection, and how can I know that I select the right Code Page?
>Thank you for your time.

Christian,

Might be something along the following lines...
*  Program...........: SET_SAARI_CP.PRG
*  Author............: José Constant                      
*  Project...........: Autosoft                           
*  Created...........: 15/10/98  20:03:48
*  Copyright.........: (c) Constant Software Systems, 1998
*  Compiler..........: Visual FoxPro 05.00.00.0415 for Windows 

CLOSE DATABASES
SET DEFA TO ("f:\saari\autocons")

gnDbfnumber = ADIR(gaTable, '*.DBF')  && Create array

CLEAR
FOR nCount = 1 TO gnDbfnumber  && Loop for number of databases
	DO home() + "tools\cpzero\cpzero"  WITH GaTable[nCount,1], 0 
	DO home() + "tools\cpzero\cpzero"  WITH GaTable[nCount,1], 1252 && your case probably 437 or 850
ENDFOR
SET DEFA TO C:\CDBK30\AUTOSOFT  && Set path to Visual FoxPro directory
Previous
Reply
Map
View

Click here to load this message in the networking platform