13 Replies Latest reply: Dec 31, 2016 11:44 AM by Clever Anjos RSS

    Can't load some value fields from a SQL Select table

    Fernando Damas Wenzel

      Hi everyone,

       

      I have one problem that is driving me nuts. Since I have very limited knowledge in SQL, maybe you guys could help me out here.

       

      I have an ODBC connection with a oracle system, and it is working just fine with every select i am making.

      But, when trying to load this table, it gives me a error connector reply: *** message.

       

      Above some images of what is happening.

       

      1. I open de connection and see the table i'm about to load:

      1.png

       

      2. When I try to load everything, no good:

      2.png

       

      3. Curiosly, when I load only the "text" values, the load executes well.

      3.png

       

      4. But when I try to load VALORH and VALORD, it doesn't load at all.

      4.png

       

      I have already tried to do a SQL SELECT *, but, again, resulted in the same error

       

       

      Anyone could help me?

       

      Thanks a lot!