rsqlserver icon indicating copy to clipboard operation
rsqlserver copied to clipboard

can't read numeric fields

Open ecastellon opened this issue 9 years ago • 0 comments

I have a table ("test") with a field numeric(8,2) or decimal(8,2) without any NULL data.

-( using windows 8; r-3.2 x64; rClr 07.4; .net framework 4.5; SQL Server 2014)

(

library("rClr") Loading the dynamic library for Microsoft .NET runtime... Loaded Common Language Runtime version 4.0.30319.34209 )

With sql server 2014 this is what I get

dd <- dbSendQuery(kk,"select c001 from test") ww <- fetch(dd,2) Error in (function () : clr_obj_ms_convert_to_SEXP: COM variant type code 14 unsupported. Returning NULL Error in clrCall(res.Dict, "get_Item", Cnames[i]) : Type: RDotNet.EvaluationException Message: Error in (function () : clr_obj_ms_convert_to_SEXP: COM variant type code 14 unsupported. Returning NULL

Method: RDotNet.ProtectedPointer evaluateCall(IntPtr) Stack trace: en RDotNet.Function.evaluateCall(IntPtr call) en RDotNet.Function.createCallAndEvaluate(IntPtr argument) en RDotNet.Function.InvokeOrderedArguments(SymbolicExpression[] args) en Rclr.RDotNetDataConverter.ConvertObject(Object obj) en c:\Users\per202\AppData\Local\Temp\RtmpuMBMYA\R.INSTALL2164365a3840\rClr\src\ClrFacade\RDotNetDataConverter.cs:línea 559 en Rclr.RDotNetDataConverter.ConvertToSexp(Object obj) en c:\Users\per202\AppData\Local\Temp\RtmpuMBMYA\R.INSTALL2164365a3840\rClr\src\ClrFacade\RDotNetDataConverter.cs:línea 369 en Rclr.RDotNetDataConverter.ConvertAll(Object[] objects, Func`2 converter) en c:\Users\per202\AppData\Local\Temp\RtmpuMBMYA\R.INSTALL2164365a3840\rClr\src\ClrFacade\RDotNetDataConverter.cs:línea 388 en Rclr.RDot

ecastellon avatar Oct 23 '15 22:10 ecastellon