>>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.

ADO is the MS solution for this. If you choose ADO, you can use the VFPCOM utility to handle the conversions.

For ultimate speed, I would look into wwIPStuff and EncodeDBF and DecodeDBF. these routines convert a cursor into a tight text string, and then rebuild the cursor.

If the COM object will have varied clients in the future, I would use either ADO or XML.