Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and SQL Server in One app
Message
From
11/02/2017 12:33:48
 
 
To
10/02/2017 14:37:31
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01647697
Message ID:
01647852
Views:
77
Likes (1)
>>>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.

I'm sorry for my late answer. My business classes were built over a long time, and I am not able to give you a single source to start with. Since you ask for help about where to start, I can recommend West-Wind Connection's wwBusiness which is a commercial product and a part of West Wind Internet & Client Tools 6.0. I also recommend the book Build Your Own Framework with Visual FoxPro.
Previous
Reply
Map
View

Click here to load this message in the networking platform