topic Blobs in QV9 in QlikView

Blobs in QV9

Wed, 15 Jul 2009 17:50:32 GMT

Hello,

I want to load Blobs via ODBC.
Generally this seems to be possible (see Blob Tab in Select-Dialog), but I stumble over details.

Currently my Blobs are in MS Access (Future: Oracle 10g).
The Blobs contain JPG images, one per record/ field.
When defining the "select" in QV, the Blob-Preview remains empty ... hm ... not a good sign.
Consequently the images do not appear in the QV App.
Driver Issues?

I know the 'workaround' to have the JPGs in the file system, and using the DB just to refer to the files.
But life is a bit more complicated than described above, so I'd like to avoid that.

Did anyone successfully load JPGs from Access or Oracle, and if yes - how?

Still hoping for positive feedback,
Thilo

Blobs in QV9

Wed, 15 Jul 2009 18:17:13 GMT

I used the following code

Foto:

INFO IMAGE_SIZE(120,120) SELECT

Name,

Photo

FROM PERSONS;

Then I had another table with the field to SNOMBRE.