Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Return a VFP cursor to ASP script
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00661367
Message ID:
00661591
Vues:
16
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform