Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert cursors to a single string and back
Message
From
30/07/1999 07:40:59
 
 
To
30/07/1999 07:09:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00248084
Message ID:
00248103
Views:
15
>>>I'm looking for a routine that can convert a cursor into a single string and back. See my post named "Do I need/can I use ADO" for more detail. I think I remember someone stated the existance of such routines here on UT ...
>>
>>I don't understand the base question, however, if what you're looking to do is move between a VFP cursor and an ADO RecordSet, download VFPCOM from the microsoft Web site msdn.microsoft.com/vfoxpro/downloads; VFPCOM is an automation engine that provides methods to freely convert between VFP cursors and ADO recordxsets, and also provides a means to bind VFP code to the events of ActiveX controls and OLE Automation Servers. It works with both VFP5 and VFP6.
>
>If VFPCOM allows to convert in both directions cursors>ADO and from ADO back to cursors and on top of that an VFP automation server can return an ADO record set to a client my problem is solved ...

VFPCOM can convert both ways - two methods, one goes rs->cursor, the other cursor->rs. AFAIK, though, there's no way to create an RS directly within VFP; you might want to look at John Petersen's Whitepaper on VFP and ADO. XML might be a better way to approach the problem.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform