blob problems (bloblems?)
lazarus / 16-Databases

----------------------------------------------------------------------
cabbage · 2009-10-14 19:32

Anyone seen this before?

 select * from sometable
Could not get field data for field "somefield" ODBC error details:
LastReturnCode: SQL_NO_DATA;

It's likely informix-specific but thought I'd see if it had been
encountered before.

----------------------------------------------------------------------
cabbage · 2009-10-15 14:06

Looks like it is informix-specific:

from Informix odbc driver Programmers Manual
"Instead of accessing smart large objects using the ifx_lo functions,
you can
access smart large objects using the standard ODBC API.
Operations supported when accessing smart large objects using the
standard
ODBC API include select, insert, update, and delete for CLOB and BLOB
data
types. You cannot access BYTE and TEXT smart large objects in this
way."

the fields it's complaining on are indeed BYTE types