Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Codepage of FPD 2.6 table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00188070
Message ID:
00188300
Vues:
16
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform