>>>Hello all,
>>>
>>>I've been using VFPCOM for the past week and initially I thought it was going to do a clean job. I'm trying to use the function RSToCursor() to create a cursor from a SQL 7 table, and for some reason is bringing only values in two or three columns rather than in all of the fields. It is bringing all the records I'm expecting, but not their full values.
>>>
>>
>>RSTocursor is flaky in more than one respect. Any reason you're using ADO instead of SPT for this?
>
>Hi Erik,
>
>I'm building a COM object which is getting data from a SQL backend and one of the requirements is not to have a VFP database holding any views or connections to it; is there any other way to connect to SQL and do processing rather than ADO?.
>

You can use SQL PassThrough and have your data returned in a VFP cursor directly...