>>>
>>VFPCOM can convert both ways - two methods, one goes rs->cursor, the other cursor->rs. AFAIK, though, there's no way to create an RS directly within VFP; you might want to look at John Petersen's Whitepaper on VFP and ADO. XML might be a better way to approach the problem.
>
>In VFP, the only way you can do a query and have it go directly to an ADO record set is to access the data via ADO in the first place, but this isn't different than any other language or data source.
I realize this; I think that he wants to create a VFP COM object and have it serve as an OLEDB provider, where it receives a query, and returns an ADO recordset; I'm not aware of a way to do that directly. The biggest problem is how to pass the ADO RS back from the COM server to the client. Do you have a way to do that?