The RSToCursor/CursorToTS Methods are meant to convert VFP data to and from ADO. One time, I tried using the RSToCursor method with SQL Server Data. Guess what? All I got back were general fields!! Not very useful < s >... I suspect you are running into the same problems with Oracle Data. It is all about data type conversions and the RSToCursor/CursorToTS Methods ability, or should I say, inability to deal with many of them...

My advice in your case is to rely on SQL Pass Through if you need your data in VFP cursor format.


>Hi John,
>
>I read your article 'ADO jumpstart ...' and was pretty hyped about using ADO rather than ODBC for accessing our Oracle 8.0 data server.
>
>However, I have run into a little problem, and I would appreciate any help you could provide.
>
>I am using the function RSToCursor() to convert the retrieved data, but none of the numeric fields convert properly. All character and date fields are parsed properly. All numeric fields have one entry as their value, 'gen'.
>
>I can write my own conversion routine in VFP, or VC++, if there is a problem, but I just wondered if there may be some known issue regarding using this conversion routine, and a workaround.
>
>TIA
>
>Sanjay