Page 1 of 1

Inserting pictures into table

Posted: Fri Jul 14, 2017 4:19 pm
by cartoonjazz
Your input is very much appreciated.
I have a table with quantities and sku numbers
I have a folder with pictures named with the sku ".jpg"
I would like to automatically have the pictures loaded into a picture column in the table based on sku is this possible?
Thanks for reading

Re: Inserting pictures into table

Posted: Fri Jul 14, 2017 11:44 pm
by Villeroy

Code: Select all

SELECT "Table".*, 'pic_folder/' || "sku" || '.jpg' AS "Picture" FROM "Table"
where pic_folder is a subdirectory of the directory where the Base document lives, "Table" is a table name, "sku" is a field name.
Bind the concatenated "Picture" field to a form's picture control.
If you want show the pictures in a report, you've got to use the report builder extension.