topic SQL vs Qlikview in QlikView https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163809#M36752 <HTML><HEAD></HEAD><BODY><P>Read page 242 in reference manual. It is possible to show BLOB images only with ODBC connection.</P></BODY></HTML> Wed, 06 Jan 2010 12:06:13 GMT 2010-01-06T12:06:13Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163802#M36745 <HTML><HEAD></HEAD><BODY><P>Can somebody please tell me how to retrieve picture from sql database using qlikview?</P><P></P></BODY></HTML> Tue, 24 Nov 2009 20:08:06 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163802#M36745 2009-11-24T20:08:06Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163803#M36746 <HTML><HEAD></HEAD><BODY><P>How is the picture saved in the database ? BLOB ?</P></BODY></HTML> Tue, 24 Nov 2009 20:17:25 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163803#M36746 2009-11-24T20:17:25Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163804#M36747 <HTML><HEAD></HEAD><BODY><P></P><P></P><P></P><P></P><P></P><P><STRONG>Check below codes</STRONG></P><P>UPDATE</P><P></P><P>[SLX_Events]. [dbo]. [QV_Table_Content]</P><P></P><BR /><BR /> <P></P>SET [qv_Image] = (SELECT * <P></P><P></P><BR /><BR /> <P></P>FROM OPENROWSET(BULK 'C:\Users\user\Pictures\marula-leaf.jpg',SINGLE_BLOB) AS a) <P></P><P></P>WHERE [qv_Id]=2<BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 24 Nov 2009 20:24:15 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163804#M36747 2009-11-24T20:24:15Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163805#M36748 <HTML><HEAD></HEAD><BODY><P>I think this thread explains it : <A href="http://community.qlik.com/forums/p/22860/87541.aspx#87541">http://community.qlik.com/forums/p/22860/87541.aspx#87541</A></P></BODY></HTML> Tue, 24 Nov 2009 20:29:41 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163805#M36748 2009-11-24T20:29:41Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163806#M36749 <HTML><HEAD></HEAD><BODY><P>Nah, it's not clear to me because i m using sql database. Try to give me a sample that load from sql database.</P><P>please help!</P></BODY></HTML> Tue, 24 Nov 2009 20:39:20 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163806#M36749 2009-11-24T20:39:20Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163807#M36750 <HTML><HEAD></HEAD><BODY><P>Are you using ODBC or OLEDB ?</P><P></P></BODY></HTML> Tue, 24 Nov 2009 21:33:32 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163807#M36750 2009-11-24T21:33:32Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163808#M36751 <HTML><HEAD></HEAD><BODY><P>i am using OLEDB</P></BODY></HTML> Wed, 25 Nov 2009 12:42:36 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163808#M36751 2009-11-25T12:42:36Z SQL vs Qlikview https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163809#M36752 <HTML><HEAD></HEAD><BODY><P>Read page 242 in reference manual. It is possible to show BLOB images only with ODBC connection.</P></BODY></HTML> Wed, 06 Jan 2010 12:06:13 GMT https://community.qlik.com/t5/QlikView/SQL-vs-Qlikview/m-p/163809#M36752 2010-01-06T12:06:13Z