none
upgrading vfp 7.1 to vfp 9.0 RRS feed

  • Question

  • What are the major issues i'm likely to face moving a vfp 7.1 application to vfp 9.0?
    Sunday, October 14, 2018 7:34 PM

All replies

  • You might get several error messages for errors that were not found by earlier FoxPro versions, e.g.

    LOCAL a b c instead of LOCAL a, b, c

    or too many closing brackets. It probably is best to correct these errors in your old version first and go on with the conversions afterwards.

    There can be problems with SQL commands. Moreover, you should set the engine behaviour for reports to 8.0.

    Good luck!

    Sunday, October 14, 2018 9:36 PM
  • Hello,

    to work in both I strongly recommend to have 2 separate folders. We got trouble when opening a project in nine, changing some forms , opening in 7 and then again in 9.

    As mentioned SQL is more strict , see on group by

    for changes you may have a look in :

    https://www.hentzenwerke.com/catalog/wnvfp8.htm

    https://www.hentzenwerke.com/catalog/wnvfp9.htm

    And search for foxypreviewer and foxcharts and look on https://vfpx.github.io/projects/ . Most of these great projects rely on vfp 9.2.

    Regerds

    tom

    Monday, October 15, 2018 7:10 AM
  • Actually, I strongly recommend you SET ENGINEBEHAVIOR 70 only long enough to get things fixed. The changes were made to prevent errors that were permitted in the older versions. Fix the queries so they don't rely on ambiguous syntax.

    Tamar

    Monday, October 15, 2018 9:02 PM
    Moderator