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 15:55:30
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
 
 
À
08/03/2002 10:30:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00630207
Message ID:
00630399
Vues:
20
>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.
>

Here are some other considerations:

- With WebConnection, you can use cursors directly to build HTML pages. Of course, it provides a lot more functionality as well.
- You might want to research the similarities/differences between ADO and ADO.NET. Will the work you do now with ADO be supported in ADO.NET?
- Of the frameworks available, COMCodeBook probably provides the best support for using ADO.
- Although converting between ADO recordsets and cursors is possible, it's not perfect. I think most of the recommendations will be to use one or the other. That's not to say you shouldn't support both, (ie. VFP front end uses cursors, ASP uses ADO), just avoid the conversions.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform