Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter and the empty promise
Message
 
 
To
27/02/2003 11:57:02
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00758706
Message ID:
00758862
Views:
13
There's also XmlAdapter to work with XML.

>>What I need is a way to quickly convert a VFP cursor to an ADO recordset (the CursorToRS functionality). I see this as a critical step in leveraging the power of VFP within an MTDLL for web/ASP applications. Basically I need to do a complex series of VFP queries within a single call to an MTDLL and quickly convert the final VFP cursor into an ADO recordset, and then pass the recordset object back to my ASP application.
>
>If you are able to create your cursor will queries, and you aren't using xBase, would it be more efficient to just create the RS by using the VFP OLE-DB provider and sending the select command to it.
>
>>but that seems very inefficient.
>
>As I said, since you have to do the step of creating an ADO connection and record set, then convert the cursor to it, it seems just sending the command to the VFP provider would be just as fast.
>
>>Any suggestions on how to solve this problem?
>
>Perhaps after you have your VFP cursor you could convert it to an ADO type XML using CursorToXML() then open the XML with ADO. If you can't do it with CusrorTOXML() I am pretty sure wwXML class lib that Rick Strahl puts out supports ADO persisted XML format.
>
>Short of that, you could use the CursorToRs() code that Ken Levy wrote. It was on his web site which I don't know if exists any more. But, he had said, even though it was native VFP it was just as fast as the code in VFPCOM.DLL.
>
>*********************
>Also, what about just returning XML to your ASP applications? (I know you have exiting ones.)
>
>BOb
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform