Rewriting a VFP 9 application into a web based application
Posted on 2014-02-26
I have a fairly extensive VFP 9 application that runs on a SQL backend with a lot of stored procedures. There are basically three classes of forms in the application. The first class uses an old third party tool, QBF Builder, for a three tab form approach to managing more static data like employees, clients, etc. (Tab 1 - Enter search criteria. Tab 2 - View a list of results based on search criteria. Tab 3 - Modify record selected in tab 2 or create a new record.) The second class of forms is for data entry of work orders, time and materials, etc. The third class of forms is to enter parameters used to build data for reports. There is a lot of coding behind all this and it will take some time to recreate it. Clients want the same functionality of the app available online and an eventual complete phase out of the VFP app.
We recently replaced a smaller VFP app for these same clients, an app that helped run their handheld computers in the warehouse, using Visual Studio 2008 for the handheld computers app and VS 2012 for a web based app that replaced the VFP coding with calls to SQL stored procedures.
That was a good approach for that smaller project, but what about something of a larger scope. There are likely 100 forms and just as many reports in VFP app. This will not be a small undertaking.
Any one out there with experience in this sort of project? Any suggestions as to the best approach? Java, Visual Studio, ???