accessing VFP3 databases using VFP7

[sumpun]

Can I use VFP7 to access databases and tables created in VFP3 without any version conversions ??

I currently have a application written in VFP3, but need to develop some tools using VFP7. Can I access the database and tables using forms and code developed using VFP7 and maintain it so that it is still usable by VFP3.
I haven't tried it yet, just in case something goes wrong !!!

CHEERS !!

Sum

 

[danceman]

If you are just accessing the data, I suggest that you use views. Also take a look at the CPCONVERT( ) Function, SET NOCPTRANS TO. Attitude is Everything

 

[rgbean]

Sum,
You should have no problems access VFP 3.0 tables from 7.0. Just don't turn on Database Events in 7.0, and all should be well!

Rick

 

[kennmurrah]

how do i turn OFF database events in vfp7? i've been trying to figure that out all day ... i "modify database" and uncheck "set events on", but i still can't access it again with the older vfp without rebuilding the dbc ...

any ideas?

thanks for the help.

 

[rgbean]

Does the Database use Stored Procedures and/or Referential Integrity? If it does, then there might be a problem if this code is compiled in VFP 7.0, especially if you use any explicit VFP 5/6/7 only code constructs (i.e. non-VFP 3.0).

Rick

 

[kennmurrah]

i'm actually using vfp 7 to attempt to modify a vfp 5 database (sorry for the confusion -- i just saw a question similar to mine and was trying to piggyback on it)

 

[sumpun]

With free tables, it is OK

But if the database contains relations and referential integrity, I can longer access it again using VFP30.

I've decided to just do a full conversion to VFP7, as I didn't have that many problems with setfocus methods within valid events.

CHEERS !!