BLOB SUCCESFULLY INTO QV (SQL)

shahamel — Fri, 04 May 2012 10:06:44 GMT

Dear users,

For those who are having problems with a blob in your database. This is my solution.

I have a SQL Database with a table which contains an employee id and a picture. This picture has the datatype image. An image is another datatype. For example you have, integer, string, etc. Image is also a datatype.

What is did is; i made connection with my database

ODBC

CONNECT32 TO [SUDBPROD SQL2008];

Then i wrote this statement. You can change the database name and the fields to make it work for yourself.

INFO SELECT EMPLID, "EMPLOYEE_PHOTO" FROM "Synaxion LVS".dbo."SDC_PSCS_EMPL_PHOTO";

The main thing is the document i added with this discussion. When you search for 'blob' in that document you get information about blob when loading information from a database.

I hope this is useful for this community.

Gr. Sandeep

topic BLOB SUCCESFULLY INTO QV (SQL) in QlikView

BLOB SUCCESFULLY INTO QV (SQL)