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
Inserting pictures into table
-
- Posts: 54
- Joined: Sun Sep 04, 2016 9:40 pm
Inserting pictures into table
openoffice 4.1.2 windows 10
Re: Inserting pictures into table
Code: Select all
SELECT "Table".*, 'pic_folder/' || "sku" || '.jpg' AS "Picture" FROM "Table"
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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice