Hi!
Take a look to the VFPCOM.DLL that have built-in function to convert ADO recordset to VFP cursor.
>Hi,
>
>I'm writing an application that will call a COM that return a recordset as result. I need to use VFP to save the recordset into a table. Is there any quick method to do so?
>
>Ok, let me assume that I use the slowest method, i.e.
>- loop through each records in the recordset
>- add a new record to dbf
>- replace each value
>- update
>But I'm having problem accessing '.Value' for field with type adNumeric, I don't know what the problem is!
>
>Also, when I try to use Recordset's GetRows method, it will return error for some table, and it's error message is so general that I dunno what the problem is.
>
>Any expert with expeience on this?? Please help!!
>
>Thx!
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.