Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return a VFP cursor to ASP script
Message
 
 
To
25/05/2002 11:31:03
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00661367
Message ID:
00661496
Views:
19
>>Assume I have a VFP COM Server being used by some ASP scripts. 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.
>
>Mark,
>I think you've answered yourself. Directly use OLEDB driver for ODBC.
>In VFP7 there are more options like OLEDB drv. for VFP, cursortoxml(), xmltocursor() etc.
>Cetin

Cetin, could you show me how to approach this situation: I have a bunch of ASP code that is written to work with a recordset that is generated from some DBFs. Because of some business logic changes, it has become a real problem to generate the recordset using SQL within ASP. However, using the VFP engine on this set of loosely related tables works great. So I want to use the VFP engine to create a cursor, and then convert the VFP cursor to an ADO recordset to pass back to my ASP application.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform