Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO x SQL-PassThrough
Message
De
17/05/2001 07:28:21
 
 
À
17/05/2001 04:23:01
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00508217
Message ID:
00508234
Vues:
22
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform