Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oledb Provider
Message
From
19/08/2002 11:51:16
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00690933
Message ID:
00691081
Views:
18
>>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform