Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Programmatically convert tables from 2.6 format
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00897229
Message ID:
00897300
Vues:
17
Hey, Sergey.

I just did a few tests and found that using the ALTER TABLE method, the whole folder with several dozen tables took about 5 minutes. Then I copied two of the 2.6 version tables, both having CDX and FPT files associated with them, back to the folder and ran another version of my program where I used COPY TO instead, and it took 4 minutes just for these two tables. So I'm sticking with the ALTER TABLE method. This test was across a network connection (both times) on test data (I never test on production data!).

I just thought you'd be interested in my results.

Dana
>>Hi,
>>
>>Does anyone know of a way to convert old 2.6 tables to VFP format tables? We are looking into bringing our free tables into a DBC and in doing some tests I see that dialog that asks about converting the table to VFP format. You can't prevent it, even with SET SAFETY OFF. I was wondering if there is a way to convert the table format first, in a program. I can't seem to find anything about it anywhere.
>>
>Dana,
>
>They will be converted if you make a copy under VFP
lc26Path = < ... >
>lcVfpPath = < ... >
>lcTable = "mytable"
>COPY CDX ( lc26Path + lcTable ) TO ( lcVfpPath + lcTable )
>
Where's the damned Any Key?...too late
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform