Discussion Board for collaboration related to QlikView App Development.
Hi guys, as I've read in the Qlikview User Reference Manual, it says the only way you can load successfully a blob image is via ODBC.
In my case I can't get the BLOB image via ODBC, it has to be by plain text file.
Is there any trick that I can do in order to get my desired result?
I've attach my sample with a qvd with two blob images and a qv document trying to load it with bundle() and info() functions.
Here you have the part of users manual that says it has to be loaded only with odbc :
Your qvd does not contain an image blob. When images are loaded into qlikview using the info or bundle keyword they're stored in a special internal $info table. That $info table can't be stored into a qvd with the STORE command.
Thanks Gysbert for answering so quickly,
I'm sorry I didn't understand what you exactly mean.
In the field Photo you have an hexadecimal number of 1496324 numbers of longitude. And it's supposed to contain the image as BLOB defined in the database, isn't it? Wich is the difference between the number you see in the photo field and the number stored in the database?
I didn't pretend to store the image (stored in $info table), only showing it properly in Qlikview.
Try when connecting with database the following script
Load Photo ID, PHoto blob from
sql select ----- ;
then on design create a text field and put
'qmem://[Photo ID]/1' as a test.
The bunble command will store the image from database on QMEM.
I also don't think it's possible to bundle load an image from a qvd directly.
However, I once tried to import pictures stored as octet strings in AD by using a VB macro to store it temporarily to disk and bundle load it from the file:
maybe this helps
Thanks Marco! I'll try creating a function in vbscript that reads blob image and exports to an image file. I bet there's something in the web that can do this.
Thanks Arthur for your answer, is mandatory to have the odbc connection? It would be lovely if I can do it from a qvd file. Could you post an example?