Good afternoon
I have a simple table with PK, and a LONGVARBINARY. In this field I store images. with smaller images this seems to work - all bmp format. Now I want to save a larger one: data size 15926 kilobytes, 3020x1080x24bit. I can save this via my created form though. However, when I close and reopen the database project, the image is not saved in the table.
Any hints and help would be greatly appreciated.
Thanks a lot
Martin
No operating system.
No office version.
No database engine.
Nothing about the facts that make you think that something is not saved in the table.
Sorry
OS:
Windows 11 Pro
Office Version:
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
Database Engine:
Embedded HSQLDB
I can enter the large image via my form. In the report I created the image is displayed.
When I close LibreOfficeBase and reopen my *.odb file, the image is not available anymore in the table. The report is empty
Wonder why there doesn’t appear an error. Might be this bug: FILESAVE: HSQLDB:Inserting big image in a form destroys all input since last opening of *.odb-file
I would never try to store such a bug image in a database. You could connect the image control to a VARCHAR field. Then the path to the image will be saved and could also be shown in report or where else you will need it.
Many thanks for the reference to the bug: This exactly the behaviour I’ve seen.
Yes, another design approrach is to only store the file path to the image, So in the report I have to find out how to actually insert the picture, as this the most important information at all: The image itself.
A picture control linked to a text column of URLs opens a file picker dialog.
Great design idea, thank you