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



      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.