>>Hi,
>> Yes, I agree that, we could use ADO/XML to send data around. How to check the changes on underlying table since converting from cursor ->ADO/XML is slow.
>>
>>Any recommendation?
>>>ADO can handle this for you. Look at the help files.
>
>I have tried to use ADO. However, it doesn't work as what we discussed here (check the changes on underlying table ) if I use CURSORTORS() to convert cursor to recordset.
>
>Do I need to use ODBC to access VFP??
>
>Thank you
Yes, ADO *does* change the unerlying database. I've used it and it works.
Currently, to get to VFP data, you will need to use ODBC. You can use the OLE-DB provider for ODBC if you want. VFP7 will ship with an OLE-DB providor.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer