4 Replies Latest reply: Feb 10, 2016 9:34 AM by Michael Bäumer RSS

    Using  the substr function to solve ODBC-Error with Progress-DB

    Michael Bäumer

      Hi,

       

      in the QV-Community i searched for a suggestion to solve the error with ODBC and Progress-DB "has value exceeding its max length or precision".


      I found this discussion https://community.qlik.com/message/624320#624320, and the suggestion (last post) to use substr()-function.


      Can someone please give an example, where and how i have to use it in the load- and select-sections?


      i can't find the substr()-function in qlikview, and getting an error while using it.


      the field is a "posting text" (length 150).


      thanks for any help.


      regards

      mike