>>>>Hi all,
>>>>
>>>>Next week I'm going to start playing with the OLEdb Provider in VFP 7.
>>>>Where can I find good usage examples? I want to explore executing stored procedures using it.
>>>>Are anywhere available examples on returning XML from a stored procedure using the OLEDb Provider?
>>>>
>>>>TIA
>>>
>>>The article
ADO Jumpstart for Microsoft Visual FoxPro Developers by John Petersen should help you started
http://msdn.microsoft.com/library/en-us/dnfoxgen/html/adojump.asp.
>>>See also
HOWTO: Execute a Stored Procedure in a VFP Database with the VFP OLE DB Provider.
>>
>>Sergey,
>>I read that article some time ago but I have never liked the ADO recordset.
>>What I'm trying to find is if it is possible to use the VFP OLE DB Provider but to return XML produced by CursorToXML from a stored procedure. Maybe I'm dreaming but I think this could be a major step towards having a VFP Server.
>
>CursorToXML function isn't supported by VFP OLE DB Provider.
Thank you, you save me hours of frustration.
Do you know of any effort in the community on building a VFP Server?
By "VFP Server" I meant sort of a VFP component or application running in the same server with the data and that receives requests, runs code and extract/process data in that server and returns let's say, XML, just resulsets to the requester.
Maria E. Zambrano