Just complete conversion of three application to VFP 9. One was a VFP7 and the other two large applications were written in VFP8.

Conversion was very sucessful and now all are running as VFP 9 applications.

Some gotcha's

In the VFP7 application I had to adjust the group by clause to include all non agggregate field in the query into the group by clause.

In the VFP8 application I had to adjust reading the _tally results in the case where the query returns only an aggregate on a query without a group by clause.

Using the Code reference option available since VFP8, it was fairly easy to make these changes.

The thing that bit me the hardest was printing reports and labels when you use the SET PRINTER TO command to select the printer. Even though they ran fine in the other versions of VFP, in VFP 9 the reports and labels printed defaulted to the default window's printer. I had to go in and make sure all printer specific commands in the report table was removed for tag1,tag2 and
expr field. In one of the labels I left several blank spaces in the tag field and it continued to select the default printer and when I final removed the two blank spaces did it work correctly. I use the print command to select printer for the Dymo label makers used in printing labels and using the FAXPRESS printer drivers to automate the faxing process. Both FAXPRESS and DYMO printer worked without a problem.

With the exceptions of the above, everything is working fine. I use a lot of automation to Excel and Word and it presented no problems. I switched to the latest version of Stonefield Database, Common Control Library by Alex Grigorjev, and XFRX and all ran without a hitch in VFP9.

The two largest applications have from 10-30 users actively accessing the data dealing in hundreds of thousand of records.

If you are considering converting over, I would suggest do it now so you can start using some of the neat stuff in VFP9. I was reluctant to do it at first, but now that it is over, I am extremely happy that I did. The whole process took about two week to make the changes and test before I went live.

AS Nike would say "JUST DO IT"

Gaylen