Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert RS to VFP Cursor
Message
De
15/07/2005 07:52:57
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Divers
Thread ID:
01032938
Message ID:
01032983
Vues:
13
>I'm trying to use RSToCursor in VFPCom. This works fine except that the resulting cursor 'disappears'. I can't figure out why.
>
>Also, is this the correct solution. I'm using a VB DLL to retrieve data from (currently) VFP DBC [going to change to MSDE later] which places data in ADO RS. This is then converted to cursor in VFP app.
>
>This is the way the app is being designed for valid future reasons.
oCon = createobject("AdoDb.Connection")
oCon.ConnectionString = "Provider=VFPOLEDB;Data Source=" + _samples +"data\testdata.dbc"
oCon.Open
oRS = oCon.Execute("select * from customer")

xDOM = NEWOBJECT('MSXML.DOMDocument')
oRS.Save(xdom, 1)
oRS.Close
oCon.close

XMLTOCURSOR(xdom.xml, "MyCursorName", 1028)
SELECT MyCursorName
BROWSE
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform