Recent

Author Topic: blob problems (bloblems?)  (Read 3704 times)

cabbage

  • Newbie
  • Posts: 4
blob problems (bloblems?)
« on: October 14, 2009, 09:32:56 pm »
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

  • Newbie
  • Posts: 4
Re: blob problems (bloblems?)
« Reply #1 on: October 15, 2009, 04:06:01 pm »
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