Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP and SQL Server in One app
Message
De
11/02/2017 12:33:48
 
 
À
10/02/2017 14:37:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01647697
Message ID:
01647852
Vues:
78
J'aime (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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform