Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programmatically convert tables from 2.6 format
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00897229
Message ID:
00897300
Views:
18
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform