what are the differences between vfp6 database and vfp9 database 2

[binhpham]

Hi All
I am upgrading my app that was written in vfp6 to vfp9.
I am wondering whether if I should create all new databases in vfp9 or reuse the old vfp6 databases.
I know we can read, write vfp6 databases in vfp9 as normal, but are there any hiden problems?
What are your advices in this situation?
Thanks for your advices

 

[AndyKr]

There are no actual differences in the structure of the VFP database container (i.e. the DBC file) itself but there are some new functions associated with the DBC (DBC Events were introduced in VFP 7.0).
The table header was changed in Version 8.0 to accommodate the auto-incrementing integer data type. And some additional data types (including VARCHAR) were added in VFP 9.0

The downside to these changes is that the VFP ODBC driver was NOT updated and will only work with Version 6.0 features.

Providing that you do not use the new data types then you will be able to access your tables in either VFP 6 or VFP 9 without any problems.


----
Andy Kramek
Visual FoxPro MVP

 

[craigber]

In addition to Andy's comments, there are also DBC Events, which if turned on change a bit in the header.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"