I follow video tutorials with instructions to add a field in the table for images with LongVarBinary. In the drop down list for field type I don’t find this data type as of the video instruction. Instead one called “Bild [BLOB]” in Swedish which stands for Image/picture [BLOB]. I use this, and when I right click on the image field in the form linked to this table field I get the right behavior, a button for opening an image file, and the image is displayed (both PNG and SVG).
But as soon as I leave the post for another one and then return, the image is gone. It doesn’t help saving after each step. Any suggestions to what the problem might be?
Hello,
Please provide what database you are using such as HSQLDB embedded or Firebird embedded or MySQL etc. and what OS you have. Also a link to what instructions you actually followed may be helpful or a sample of the Base file.
Hello,
Appears you are using a Firebird embedded database. If so, this is yet another snafu.
Typically do not use embedded images personally (rather linked) but had tested this some time ago without problems. Current v6.2.3.2 does not display the images. Reloaded v6.0.2.1 (tried 6.1.x but that seemed to fail also) and all was OK.
This is a bug (regression) and should be reported here → Bugzilla.
As a note, using v6.2.3.2 has no problem with linked images or embedded images with Firebird server. Problem may lie within SDBC connector.
Edit:
There is a relative bug report here:
https://bugs.documentfoundation.org/show_bug.cgi?id=121886
This mentions problem going back further than what I found. My testing shows v 6.0.2.1 works OK.
Edit #2:
Surprising test, taking the Base file created using v6.0.2.1 and using that in v6.2.3.2, the images work just fine. Appears there is an incorrect setting somewhere. If I do find it, will post.
Further test now work creating even new Base files. Possibly something got reset when I reloaded older versions. All new and original (those that originally failed when I started this post) Firebird embedded Base files with embedded images now work. Possibly try resetting User Profile from menu Help->Restart in Safe Mode...
The issue was resolved by changing the field type from Image [BLOB] to just BLOB [BLOB] and setting the standard value for data. It seems that something went wrong with the setting of this standard value for the Image [BLOB] field when it was set up. Now the small size Blissymbol images - both PNG and SVG - are displayed and stored persistently.
I am using Firebird database, yes - on Windows 10. Video tutorials obviously for earlier versions of Base and not for Firebird.
Thanks for reply!
@matsi You are correct. Image[BLOB] is still the problem. Was getting the two crossed when testing. Bug report in my answer covers the Image[BLOB].