Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: Prajeesh Nair
  Where is Prajeesh Nair?
 Chennai
 India
 Prajeesh Nair
 Tags
Subject: RE: VFP2.6 to VFP9.0
Thread ID: 209648 Message ID: 209663 # Views: 2 # Ratings: 0
Version: FoxPro 2.x for Windows Category: Projects and Design
Date: Tuesday, December 30, 2008 11:04:37 AM         
   


> Dear all
>
> I am planning to convert one application which is developed in visual foxpro 2.6(windows) version to VFP9.0(backend SQL server). Is there any tool is available for this conversion? or if it manually, what are the issue may occurs during this converion.
>
> Kindly share your experience with me
>
Hi Prajeesh,

As for converting FoxPro 2.x to Vfp -
Many experts would recommend to rewrite rather than trying to convert, in order to take advantage of the new designers and the OOP implementation in Vfp.
You can however try to run the code as it is -
if you want to continue using @ say and @ get, you may want to set _screen.Themes=.F.
See also "Set StrictDate", "Set TableValidate", "Set EngineBehavior" in (Vfp) help.

As for converting from Fox tables to a Client/Server backend -
Again, rewriting might be preferable because pure Fox design usually relies on availabilty of entire tables, i.e. Seek(), "Locate For" and the typical "Use", "Set Order To", "Browse" approach.
While with an ODBC connection, usually all Grids are empty in the first place and the user might set filters first before querying the actual backend.
IOW, in a client/server design you might rarely want to display an entire table in a Grid because the query would run several minutes if it does not exceed the 2GB limit anyway.
See also Ken Murphy's article on RDBMS backends in the Foxite FAQ section: https://www.foxite.com/faq/default.aspx?id=54



hth
-Stefan

ENTIRE THREAD

VFP2.6 to VFP9.0 Posted by Prajeesh Nair @ 12/30/2008 9:02:28 AM
RE: VFP2.6 to VFP9.0 Posted by Stefan Wuebbe @ 12/30/2008 11:04:37 AM
RE: VFP2.6 to VFP9.0 Posted by Bhushan Sahni @ 12/30/2008 11:21:23 AM
RE: VFP2.6 to VFP9.0 Posted by Stefan Wuebbe @ 12/30/2008 11:24:58 AM