Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert RS to VFP Cursor
Message
From
15/07/2005 07:52:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Miscellaneous
Thread ID:
01032938
Message ID:
01032983
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform