Skip to content

can't read numeric fields #22

@ecastellon

Description

@ecastellon

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions