Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New VFP7/SQL-Server app -- Is ADO worth it?
Message
From
08/03/2002 15:55:30
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
08/03/2002 10:30:11
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00630207
Message ID:
00630399
Views:
21
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform