0 Replies Latest reply: Apr 16, 2015 3:39 PM by Guilherme Vieira de Stefani RSS

    Conexão ODBC falhou - value is too big

      Hello Everybody,

       

      I'm exploring Qlik view in my work, and I am finding some  problems with two situations: I'm using a ODBC connection to a caché database. When I try to get a column named NotaFiscalItem.vlrICMS (NUMER) or Item.nome (STRING).

       

      When I reload, I receive this message:

       

      Conexão ODBC falhou

      SQL SELECT

        NotaFiscal.codEmpresa,

        NotaFiscal.numero,

        NotaFiscal.codRepresentante,

        NotaFiscal.prazoMedio,

        NotaFiscal.vlrICMS,

        NotaFiscal.vlrICMSSubstit,

        NotaFiscal.vlrIPI,

        NotaFiscal.vlrLiquido,

        NotaFiscal.vlrTotal,

        NotaFiscal.codCliente,

        Representante.nome,

        NotaFiscalItem.codNatOperacao,

        NotaFiscalItem.qtdeFaturada,

        NotaFiscalItem.precoUnitario,

        NotaFiscalItem.vlrPISProp,

        NotaFiscalItem.vlrCOFINSProp,

      NotaFiscalItem.vlrICMS,

      NotaFiscalItem.vlrIPI,

        NotaFiscalItem.vlrICMSSubstituto,

          NotaFiscalComp1.pesoBruto,

        NotaFiscalComp1.pesoLiquido,

        NotaFiscalComp1.qtdeVolumes,

        NotaFiscalComp1.codTransportadora,

        Item.codigo,

      Item.nome

      FROM Esv.Cliente Cliente,

      Cgi.Item Item,

      Fat.NotaFiscal NotaFiscal,

      Fat.NotaFiscalComp1 NotaFiscalComp1,

      Fat.NotaFiscalItem NotaFiscalItem,

      Fat.NotaFiscalProdItem NotaFiscalProdItem,

      Fat.Representante Representante

      WHERE Cliente.codCliente = NotaFiscal.codCliente

      AND Cliente.codEmpresa = NotaFiscal.codEmpresa

      AND Representante.codEmpresa = Cliente.codEmpresa

      AND Representante.codEmpresa = NotaFiscal.codEmpresa

      AND Representante.codRepresent = NotaFiscal.codRepresentante

      AND NotaFiscalProdItem.codEmpresa = Cliente.codEmpresa

      AND NotaFiscalProdItem.codEmpresa = NotaFiscal.codEmpresa

      AND NotaFiscalProdItem.codEmpresa = Representante.codEmpresa

      AND NotaFiscalProdItem.dataEmissao = NotaFiscal.dataEmissao

      AND NotaFiscalProdItem.numero = NotaFiscal.numero

      AND Item.codigo = NotaFiscalProdItem.codProduto

      AND NotaFiscalItem.codEmpresa = Cliente.codEmpresa

      AND NotaFiscalItem.codEmpresa = NotaFiscal.codEmpresa

      AND NotaFiscalItem.codEmpresa = NotaFiscalProdItem.codEmpresa

      AND NotaFiscalItem.codEmpresa = Representante.codEmpresa

      AND NotaFiscalItem.codItem = NotaFiscalProdItem.codItem

      AND NotaFiscalItem.dataEmissao = NotaFiscal.dataEmissao

      AND NotaFiscalItem.dataEmissao = NotaFiscalProdItem.dataEmissao

      AND NotaFiscalItem.numero = NotaFiscal.numero

      AND NotaFiscalItem.numero = NotaFiscalProdItem.numero

      AND NotaFiscalItem.codProduto = NotaFiscalProdItem.codProduto

      AND NotaFiscalComp1.codEmpresa = Cliente.codEmpresa

      AND NotaFiscalComp1.codEmpresa = NotaFiscal.codEmpresa

      AND NotaFiscalComp1.codEmpresa = NotaFiscalItem.codEmpresa

      AND NotaFiscalComp1.codEmpresa = NotaFiscalProdItem.codEmpresa

      AND NotaFiscalComp1.codEmpresa = Representante.codEmpresa

      AND NotaFiscalComp1.dataEmissao = NotaFiscal.dataEmissao

      AND NotaFiscalComp1.dataEmissao = NotaFiscalItem.dataEmissao

      AND NotaFiscalComp1.dataEmissao = NotaFiscalProdItem.dataEmissao

      AND NotaFiscalComp1.numero = NotaFiscal.numero

      AND NotaFiscalComp1.numero = NotaFiscalItem.numero

      AND NotaFiscalComp1.numero = NotaFiscalProdItem.numero

       

      I tried to use the function Num(NotaFiscalItem.vlrICMS, '#0.00'), or Round(NotaFiscalItem.vlrICMS, 0.01) without success. With the String column I even tryed because I didn't find any information...

       

      Tks for while!