Discussion Board for collaboration on QlikView Scripting.
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.
You use it in the Select-section.
thanks for your answer.
so the syntax is only "substr(BuchungsText,1,150) " ?
do i have to add any " as tempBuchungsText" ?
If i do as you discribed, what will i have to do in the load-statement to get this field?
Probably like this:
SQL SELECT substr(BuchungsText,1,150) as BuchungsText FROM database;
thank you very much!