Func_odbc and commas within database fields

Hi,

I’ve noticed that having a comma in database field value breaks ODBC_FETCH function (wrong values are assigned to hash elements). There is a parameter “escapecommas” in func_odbc.conf, but setting it to “yes” or “no” does not make a difference. What is the recommended way to resolve this, other than not having commas in database?

After further investigation, ODBC_FETCH works fine with commas. The problem stems from the fact that I am using AEL, and ODBC_FETCH does not work well when using native AEL assignment syntax. Set() application must be used instead.

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.