How to use/insert in Crystal Reports 11.5 data-column with data-type:Picture (BLOB)
Posted on 2008-10-02
I use Crystal Reports 11.5. I connect to DB2 (IBM) in the backgroud. I connect successfully. I write a SQL to select * from table. Table has colum of type Picture (BLOB right?). When I try to insert field into report, I get error: "Failed to retrieve data from the database." (I click Ok) & then I get:"Database Connector Error: '0F001:[IBM][CLI Driver][DB2] SQL0423N Locator variable "1" does not currently represent any value. SQLSTATE=0F001 [Database Vendor Code: -423 ]'
I read that Crystal 11.5 allows you to work with BOLBs (Picture datatype field).
Can I read and parse a Picture type field, or NOT?
And if I can/should, how do I do it?