Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New VFP7/SQL-Server app -- Is ADO worth it?
Message
De
08/03/2002 11:13:36
 
 
À
08/03/2002 10:30:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00630207
Message ID:
00630246
Vues:
27
It all depends on your needs. How big will the app scale? What will happen when you physically separate the tiers? Will you need to interact with non-Fox components? BTW, binding objects to ADO is not that difficult. All Fox UI objects, except the grid, will bind to ADO. One problem with remote views is that you can't call stored procedures, which give you better performance and security.

>I am rewriting an existing vfp application that uses native fox tables. In the re-write, SQL-Server will be used as the backend.
>
>I have used VFP remote views for c/s apps and am fine with that technique.
>
>I believe we will have an easier time creating a web-based app in the future if I begin this project using a middle-tier w/ ADO.
>However, I am not sure how much time using ADO w/ VFP, rather than remote views, will add to the project.
>
>I guess I would still use VFP cursors w/ the ADO. For example,
>Retreive:
>SQL-Server -----> ADO recordeset -----> VFP cursor (easier to bound, etc.)
>
>Update:
>VFP cursor ------------> ADO Recordset ------------- SQL-Server
>
>Am I looking for unnecessary trouble if I use ADO rather then just keeping it simple?
>
>Any thoughts will be apppreciated.
>Thanks - Mark
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform