Hi!
I read somewhere here that latest ADO version(s) (8.0 or such) have built in function to convert ADO recordset into VFP cursor.
In addition, you may try wwXML class from West-Wind, it contains special methods to convert ado-style XML into VFP cursor.
>Hi,
> I am attempting to use an ADO recordset to return the data for a report to a VFP client.
> The report server:
> 1.) Accesses the required data and generates a result cursor for the report
> 2.) Packages it as a client-side (static) ADO recordset via VFPCOM's CursorToRS() method
> 3.) Passes the recordset to the VFP client
>
> The VFP client
> 1.) Copies the ADO recordset's data to a new cursor via VFPCOM's RSToCursor() method
> 2.) Generates the report
>
> Unfortunately the call to RSToCursor() results in -10=Failed to Create Fox Cursor as reported in thread #
338633> I have examined the ADO recordset and all of the data including the numeric fields appears to be present.
> I seem to remember that someone wrote an ADO to VFP cursor conversion class before VFPCOM.DLL came out.
>
> Could someone please tell me where to get a copy?
>
>Thanks in Advance,
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.