Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oledb Provider
Message
De
19/08/2002 11:51:16
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00690933
Message ID:
00691081
Vues:
17
>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform