topic Re: HOW TO TAKE BLOB FIELD FROM DB TO QV DOCUMENT in QlikView

HOW TO TAKE BLOB FIELD FROM DB TO QV DOCUMENT

Wed, 19 Dec 2012 12:12:38 GMT

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.

Re: HOW TO TAKE BLOB FIELD FROM DB TO QV DOCUMENT

Mon, 24 Dec 2012 09:23:41 GMT

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..

Re: HOW TO TAKE BLOB FIELD FROM DB TO QV DOCUMENT

Tue, 15 Jan 2013 10:35:55 GMT

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

Re: HOW TO TAKE BLOB FIELD FROM DB TO QV DOCUMENT

Tue, 15 Jan 2013 11:30:49 GMT

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)

Re: HOW TO TAKE BLOB FIELD FROM DB TO QV DOCUMENT

Tue, 15 Jan 2013 15:43:50 GMT

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