Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO x SQL-PassThrough
Message
From
17/05/2001 07:28:21
 
 
To
17/05/2001 04:23:01
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00508217
Message ID:
00508234
Views:
23
You can't efficiently use SQL Pass Through for n-tier applications. The cursor will be generated in the middle-tier. So, to get the data to the UI, you need to convert the cursor to a text string or ADO. Just use ADO to begin with for all your data access.

>Hi, Everybody!
>
>I'm just starting to study and do n-tier development, and I'm with a couple of doubts, that I'm solving on each thread here on UT. :-)
>
>Please, for every issue (performance, beauty, etc...), what would do the best approach to pass data through objects and layers:
>
>* Use ADO everywhere
>
>or
>
>* Use SQL-PassThrough to access data, and after work with this data, create a "fabricated" RecordSet, and populate it, and later pass it ahead??
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform