Craig,
Off topic, but just a quick side trip:
Where can I find the VFP7 OLE-DB provider? I have installed the complete VS.Net beta, but don't see the OLE-DB provider for VFP7 anywhere. Where should I be looking?
Thanks!
>>>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.
"Problems cannot be solved at the same level of awareness that created them." - Albert Einstein
Bruce Allen
NTX Data