Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help with Binary Object display

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.

Tags (3)
Community Browser