HOW TO TAKE BLOB FIELD FROM DB TO QV DOCUMENT

[#1]

Hi,

I am doing a report that show people who works in our department. There is a table that keep all data in it. EmployeeId,Name, Surname,Picture(Blob type),.. etc.. I want to show all information about a person in a table. It is a bit hard for me taking image from databese(ORACLE) and show it in table. İmage type is Blob. I try to make it like this ;

Pictures:

INFO SQL Select

           ID,

           PICTURE

FROM DB_NAME."TABLE_NAME";

Load ID,

         PICTURE;

When I do like this I get a table that name is $orphan_ID and there is only one field in it. the field is only ID. I can't reach PICTURE field. Please help me in this subject. I read all discussion about this topic and try all thigs that mentioned but I cant do it.

[#2]

is there  anyone to help me in this subject? How can I take BLOB file from my Oracle DB to my qlikview report. Please help me..

[#3]

Hi,

coming to late probably , anyway this is the solution that works for me reading from Oracle:

ODBC CONNECT TO [CDBCBMS;DBQ=CDBCBMS ];

          PROJECT_IMAGES:

          SQL SELECT PRJ_CD

          FROM REX_PRJ_ACTIVE_INFO;

          BUNDLE SQL SELECT PRJ_CD, IMAGE_MAP

          FROM REX_PRJ_ACTIVE_INFO;

Hope this can help you.

Andrea

[#4]

Thank you very much for your reply.. Is the image field "IMAGE_MAP"?  and Is the key field "PRJ_CD"?   I want to use qvd file. Can I write this;

.....

STORE REX_PRJ_ACTIVE_INFO into A.qvd;

DROP TABLE REX_PRJ_ACTIVE_INFO ;

LOAD

...

FROM A.qvd(qvd)

?

[#5]

Hi,

no the only thing that you can do is to read the two fields: PRJ_CD that is the project id and IMAGE_MAP that is the blob field.

What I have done was to use the code above in one qvw and read this qvw as binary in my presentation document.

This give me a logical separation from the user document and the "technical" part.

Remember that you have to use ODBC not OLE DB.

Andrea