Search results

Solved: {fn CONVERT(fieldname, SQL_VARCHAR) } "SELECT {fn CONVERT(zchar, SQL_VARCHAR) } FROM ln" Accessed as EXPR_1, as in rs("EXPR_1").

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...