I am using MS OLE DB provider for Oracle to access record sets from our Oracle server. When I use the RSToCursor() function in the class vfpcom.vcx, all character values are parsed correctly, however, all numeric values return (correct column names, but) 'gen' as the field value.

Is the conversion treating it as a general field? The original field attributes of the recordset being returned by going through the listed fields collection properties are;


Type, DefinedSize, ActualSize, NumericScale, Precision
139, 20, 5, 0, 0

I would appreciate any help on this.

Many thanks,