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
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";
Blobs
The
Blobs page makes it possible to bundle so-called Blobs, Binary
Large Objects, in a QlikView document. It is usually a picture, a
text file or similar, stored as a single entity in a database management
system. The icon indicates that the field contains a blob.
The blobs in the database are listed together with size, in KB, and
type in the
Blob Viewer . The Blob is previewed next to the list if it
is an image. QlikView supports jpg, png, bmp, pdf and rtf blobs.
Bundle
The
Bundle button opens the Bundle Dialog where the
Key Field for the Blob data
is selected and the blob can be
resized to fit in the table cell if it is an image. Mark
Shrink
246
Images
and apply width and height to resize the images to
fit. The setting does not handle aspect ratio.
I hope this is useful for this community.
Gr. Sandeep
