Ask Your Question
0

Image can be inserted into an image field in a form, but is not stored. Why?

asked 2019-05-20 16:35:14 +0200

matsl gravatar image

updated 2019-05-20 19:53:27 +0200

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?image description

edit retag flag offensive close merge delete

Comments

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.

Ratslinger gravatar imageRatslinger ( 2019-05-20 16:47:28 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-05-20 20:23:03 +0200

matsl gravatar image

updated 2019-05-20 20:40:40 +0200

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!

edit flag offensive delete link more

Comments

@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].

Ratslinger gravatar imageRatslinger ( 2019-05-20 20:49:50 +0200 )edit
0

answered 2019-05-20 19:26:38 +0200

Ratslinger gravatar image

updated 2019-05-20 19:55:04 +0200

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/s...

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...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-20 16:35:14 +0200

Seen: 40 times

Last updated: May 20