Displaying Images Stored in the DB

Started by Tim B., February 11, 2009, 10:26:33 AM

Previous topic - Next topic

Tim B.

I've managed to get images stored in the DB displaying in Genero now by using the textcopy utility in SQL Server to write out the image to a temporary file and displaying the file to the IMAGE on screen.

I thought I might also be able to do it directly by loading the image into a BYTE variable and displaying that directly, eg:-

Code (genero) Select
DEFINE l_img BYTE

LOCATE l_img IN MEMORY

SELECT img INTO l_img
FROM mytab
WHERE ...

DISPLAY l_img TO img


However, as you've probably guessed, this fails on the DISPLAY because it expects a path, not the byte data itself.   Are there any plans to allow this sort of functionality?

Sebastien F.

Tim,

Discussed internally:
It should be possible to display BYTE images directly to fields...
We will investigate and try to implement this.
But it will probably only be in 2.20.

Seb

Sebastien F.

Tim,

We started to implement DISPLAY BYTE to IMAGE fields, and we found a good solution.
However, we have other features scheduled for now and DISPLAY BYTE may not be in the next 2.20 GA.
We will for sure support that in a near future.

Seb