>Hello all,
>I want to build three-tier application.
>If my bussiness object is an OLE Automation server created by VFP. It access SQL Server data through SQLExec functions (SQL Passthrough), i get a cursor. How to pass the cursor to my application using the OLE Server bussiness object ?. (I can access SQL Server from my OLE Server by ADO and pass ADO recordset to my client easily and then convert to cursor, but i think it's slower than !). Thanks for any help !.
>
>In other application, i try use ADO and VFPCOM utility. I create Hierarchical Recordset by SHAPE COMMAND. How can i display this recordset like using Microsoft Hierarchical Flexgrid ( I can't see the DataSource property if i use it)?
>
>Thank in advance.
You can't pass a cursor in this manner. The best options are to use ADO or XML. You could also convert the data to a string or array and then parse it.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer