Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return a VFP cursor to ASP script
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00661367
Message ID:
00661591
Views:
17
>What's the best way to return a VFP cursor (or at least the contents of a VFP cursor) to an ASP script such that the contents are structured and therefore accessible as rows and columns like an ADO recordset object? I've seen posted here that VFPCOM is not reliable as a cursor-to-recordset translator. Thanks very much.

Instead of VFPCOM you can use OLEDB library (file #10002 in downloads) for conversion between cursors and ADO recordsets. It faster than VFPCOM and (AFAIK) free of bugs.
oOleDb = CreateObject("OleDbFox.Utils")
oRecordSet = CreateObject("ADODB.Recordset")
oOleDb.CursorToRs(oRecordSet)  && converts a cursor in current work area
*oOleDb.CursorToRs(oRecordSet, "MyCursor")  && converts a specified cursor
Previous
Reply
Map
View

Click here to load this message in the networking platform