Help with Binary Object display

Mon, 24 Nov 2014 13:48:30 GMT

Good day

I have the following issue:

I have a MySQL dbase with four tables.

1st table (core) contains the main information about the row content, with a primary key named URI

2nd table (image_blb) contains the topleveluri (foreign key) to the core table, also contains the column value, which contains the BLOB (Binary Library Object)

3rd table (image2_blb) contains the topleveluri (foreign key) to the core table, also contains the column value, which contains the BLOB (Binary Library Object)

4th table (image3_blb) contains the topleveluri (foreign key) to the core table, also contains the column value, which contains the BLOB (Binary Library Object)

Now the problem that I am faced with, is that when I use the following script:

ODBC CONNECT TO MySQL_CLICK_64Bit

[IMG1_BLB]:

SQL SELECT

`_TOP_LEVEL_AURI` as '_URI',

VALUE as IMG1

FROM `dbase`.`image1_blb`;

//-------- Start Multiple Select Statements ------

INFO SELECT VALUE as IMG1,

VALUE

FROM `dbase`.`image1_blb`;

//-------- End Multiple Select Statements ------

The above listed query works 100% fine for table (image1_blb) to display each image that corresponds to the selected ID (URI).

But when I duplicate that above statement for table (image2_blb) only the first image is displayed, irrelevant of the selection changes of the ID (URI).

On the front end using a Text Object, set to display Image, and using the expression =info(IMG1)

Any help regarding this would be greatly appreciated.

topic Help with Binary Object display in QlikView

Help with Binary Object display