Hello all,
I’m wondering if somebody had this challenge before.
I have a DB BLOB field, where stored in a PNG image with Scriptcase as an Image (Database).
I want to show this image in another grid by adding manually a field and retrieve the image by SQL.
I select the image by a traditional SELECT image FROM table and assign the content to a variable. So far so good, but running the code below in the onRecord event shows correctly the echoed image outside the grid (second code line), but not the image assigned to the field (third code line).
The field {icon_field} is of type “HTML Image”. I tried also with field type “Image (File)”
$icon = base64_encode($image_in_db_blob_field);
echo $img = '<img src="data:image/png;base64,' . $icon . '">';
{icon_field} = $img;
Glad, if somebody has any suggestion in how set the custom field in order to show the image content.
Thx