Displaying Images Stored in the DB

[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 Expand

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