>>My company has a legacy system running pure VFP8.
>>One of our client wants to move to sql server as a back end.
>>We thought about rewriting the app using c#.
>>But have decided to use the same VFP code and simply adding SQL server capability...... with same table structures.
>>
>>So, the app can run in full VFP mode. or full SQL SERVER mode.
>>
>>Can anyone make an argument AGAINST doing such thing?
>>
>>Thanks in advance..
>
>I support your suggestion. I have done the same by adding business classes for each table, which makes it possible to change data source by simply setting a property. And since this can be done separately for every table, you don't have to switch every table simultaneously. One thing I recommend though, is to use VFP9 instead of VFP8, since there are so many more tools available for VFP9. Thor is only one of them.
Hi Tore. I was attracted to your suggestion about business classes. I have client/server app that uses SQL Server as a backend but I would like to have it use MySQL or PostgreSQL instead just by changing a few properties. Could you tell me where can I learn to develop such business classes?
Thanks in advance.