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

[mikefromoke]

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

[jerrysvensson]

You use it in the Select-section.

[mikefromoke]

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?

regards

mike

[jerrysvensson]

Probably like this:

Table:

LOAD BuchungsText

SQL SELECT substr(BuchungsText,1,150) as BuchungsText FROM database;

[mikefromoke]

Thanks,

it works!

thank you very much!

regards

mike