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