Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL vs Qlikview

Can somebody please tell me how to retrieve picture from sql database using qlikview?

7 Replies
Not applicable
Author

How is the picture saved in the database ? BLOB ?

Not applicable
Author

Check below codes

UPDATE

[SLX_Events]. [dbo]. [QV_Table_Content]



SET [qv_Image] = (SELECT *



FROM OPENROWSET(BULK 'C:\Users\user\Pictures\marula-leaf.jpg',SINGLE_BLOB) AS a)

WHERE [qv_Id]=2



Not applicable
Author

Not applicable
Author

Nah, it's not clear to me because i m using sql database. Try to give me a sample that load from sql database.

please help!

Not applicable
Author

Are you using ODBC or OLEDB ?

Not applicable
Author

i am using OLEDB

Not applicable
Author

Read page 242 in reference manual. It is possible to show BLOB images only with ODBC connection.