The CursorToRS() is easy if you cheat!! In My Cursor to RS I pass it a parameter of the Location and Name of the Cursor. Then in the Com Object i open it using ADODB that in turn creates a record set and then you return the record set. Kind of Sloppy but for what I am looking for it works.


>Actually, it's not simple if you think about it- in CursorToRS(), how does the COM object see the table in the first place? In RSToCursor(), how does the remote process create a cursor in the local datasession?
>
>If you know how to create a COM object in VFP that can see the datasession of its caller, please enlighten us.
>
>
>
>>The idea is actually very simple. VFPCOM fabricates an ADO recordset with the same structure as the VFP table. The records from the VFP table are then marshaled to the new ADO recordset. Once that process is complete, the recordset is returned to the calling program.
>>
>>>I have been working with the VFPCOM utility for 2 weeks and have found that I do not get Numeric Values from a Recordset into a cursor using the RStoCursor() function. (Note: we are using Free tables) I decided to write my own DLL that will create a Cursor. Everything works if I make it a Function within my app. We (as a Company) want to create a DLL out of this. I now have my own CursorToRS() working in the DLL but I can not figure out how to create a Cursor from this DLL into the Calling Program. Does anybody know how the VFPCOM.DLL Creates a Cursor in the local sesion of VFP? I know you can not pass back a cursor.. is it using some Low Level stuff I am unaware of?
>>>
>>>Try to get more confuesed that this! Thanks to a anybody and Everybody.