Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using ADO to export VFP data
Message
From
10/06/1999 13:29:17
 
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00228406
Message ID:
00228493
Views:
9
Hi Tim
Funny you should ask. I was creating a VFP com server to export the recordset. I was passing the query parameters to the VFP server and having it create a cursor and export it to a file. It just seemed like a lot of overhead, creating a recordset in VFP that I already had in ADO - thought there might be a better way. If you don't mind me asking - is it a simple process to convert an ADO recordset object, passed to a VFP component, into a VFP cursor? Currently I am passing the query parameters used by the ASP page to the VFP server to create the cursor.

Thanks
Bill

>Why not pass the ADO recordset to a VFP Component, Convert the Recordset to a VFP cursor, and then save the cursor to whatever format you need with the COPY TO VFP command?
>
>>Thanks Tim
>>Most of our clients ask for data to be transferred as an sdf file, or as a comma delimited file. I need to send them the data in a format they can easily import into whatever data management program they may be using. I know that XML is the way things seem to be headed, but for now I need a format they can understand.
>>
>>Bill
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform