Foxpro version compatibility

Visual FoxPro General

Econdoc


I have many applications written in Visual Foxpro 6.0. I probably should upgrade to Version 9.0. My major concern is whether my old applications will run in Version 9.
Can someone advise me Will I have problems How major

Thanks.
Top

Re: Foxpro version compatibility

Naomi Nosonovsky


You should be OK. You may have to review all your select-sql statements, especially that involve Group BY.




Top

Re: Foxpro version compatibility

Alex Feldstein

Generally you should have no problems.

The two major areas that might give you a little trouble are SQL queries where you have aggregation using GROUP BY. The language is now more ANSI 92 compliant and some queries doen before could give errors. Now it forces you to do them right.

See:

http://fox.wikis.com/wc.dll Wiki~Enginebehavior

http://msdn2.microsoft.com/en-us/library/ax9aye37(VS.80).aspx

In any case, you should fix your queries. Set Enginebehavior is there to get you running in a short time, but does not fix the underlying problem and you could potentially be returning wrong results.

VFP9 does a stricter check of file integrity. This may give you problems with some tables that have some corruption issues that were previously undetected.

See:

http://msdn2.microsoft.com/en-us/library/a368y56z(VS.80).aspx

http://fox.wikis.com/wc.dll Wiki~SetTablevalidate

HTH



Top
  • The team •