Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert FOXPRO 2.0 FILES TO VFP 6.0 DATABASE 1
- Thread starter venado
- Start date
-
1
- #2
GrigoreDolghin
Programmer
Hello.
First of all, the Visual FoxPro Database is a "container". You cannot convert a table (which is "contained in"
into a container of something.
The second: if you want to convert the tables into "free tables" you dont' need a VFP database at all. The role of a VFP database is, primarily, to eliminate the free tables, including them in a container.
The third:
To convert FPW tables into a VFP database, you need to create the database. The easy way: create a project in that directory. Open it in Project Manager. Add the brand new database to it. Select the database in the treeview. Click on the + sign. Select 'Tables' in the treeview, then click 'Add'. And add the FPW tables. At first opening of a table, VFP will automatically and transparently convert the table to VFP format (internally, it will modify some bytes in the file header, but you don't need to know all this - it will be done automatically).
Hope this helps.
Grigore Dolghin
First of all, the Visual FoxPro Database is a "container". You cannot convert a table (which is "contained in"
into a container of something.The second: if you want to convert the tables into "free tables" you dont' need a VFP database at all. The role of a VFP database is, primarily, to eliminate the free tables, including them in a container.
The third:
To convert FPW tables into a VFP database, you need to create the database. The easy way: create a project in that directory. Open it in Project Manager. Add the brand new database to it. Select the database in the treeview. Click on the + sign. Select 'Tables' in the treeview, then click 'Add'. And add the FPW tables. At first opening of a table, VFP will automatically and transparently convert the table to VFP format (internally, it will modify some bytes in the file header, but you don't need to know all this - it will be done automatically).
Hope this helps.
Grigore Dolghin
If you want it to be converted runtime you could think of a scheme where you create a data base container with empty tables, views, indexes etc.
Open your old tables and append the records to the new database container tables.
You should be aware of referential integrity, though.
To create database containers runtime check out the GenDBC.prg that comes with Visual studio.
HTH, Weedz
veld4663@exact.nl
'It never hurts to help...' - Eek the cat.
Open your old tables and append the records to the new database container tables.
You should be aware of referential integrity, though.
To create database containers runtime check out the GenDBC.prg that comes with Visual studio.
HTH, Weedz
veld4663@exact.nl
'It never hurts to help...' - Eek the cat.
- Status
Similar threads
