Default Field Width & Openlink/ODBC

K

kmason

New Member
Hello,

When trying to access a particular field through ODBC I am only able to get 4 of the 8 characters of the field. I've seen this is an issue where the default field width (sql-width or such) is set to something, however there is data which goes beyond that. I suspect since the db was customized for our version of the system someone just forgot to set that value.

I am not very experienced in the nuances or actual server side programming for Progress, just looking for the data. I was hoping someone would know of a query command to force the extra characters.

"SELECT zchar FROM ln"

I've searched this forum every way possible for hours and have not seen a definitive answer to this problem. If anyone could help I would very much appreciate it.

Thanks
 
Solved:

{fn CONVERT(fieldname, SQL_VARCHAR) }

"SELECT {fn CONVERT(zchar, SQL_VARCHAR) } FROM ln"

Accessed as EXPR_1, as in rs("EXPR_1").
 
You must log in or register to reply here.
Back
Top