Can you insert a picture into a database field. If so how ? [closed]

asked 2015-11-10 18:52:49 +0100

Mark37421
1 ●1 ●1 ●1

updated 2020-09-01 15:31:11 +0100

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20844 ●19 ●60 ●59 http://etmg.altervista...

I'm new to this software and would like to know how to insert a picture into a database field.

Can this be done ? If so how ?

Version: 5.0.3.2 Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75 Locale: en-US (en_US) Libre office Database Window 10 PC

Thanks, Mark

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-01 15:32:30.411741

add a comment

2

answered 2015-11-12 05:09:46 +0100

JohnD

1325 ●10 ●15 ●28

Welcome to LibreOffice and this forum.

In the table that you want to insert pictures - make a field with a field type of Image [LONGVARBINARY].

In your form or report, insert the Image field and size it however you desire.

You enter pictures into this field by right clicking on the form field and selecting Insert Image from . . .

It then opens the file file browser for you to find and select the desired image file.

Once the field is populated you get an additional option to Remove Image, if desired.

Keep in mind that large image files will make a large database table that may slow things down a bit. Try to keep the picture resolution as low as possible (smaller file sizes).

edit flag offensive delete link

Comments

Thanks for this. I was trying to insert directly into the table, but it has to be through a form.

Pansmanser ( 2018-10-09 12:21:17 +0100 )edit

add a comment

0

answered 2015-11-11 16:41:04 +0100

LKeithJordan

537 ●14 ●19 ●24 http://lkjcpa.com/

I don't have access to LO Data right now, so I'm writing "off the top of my head" from fairly extensive experience with MS-Access (which is similar).

You don't actually "insert a picture into a database field." Instead, you enter the link to the picture file (png, jpg, etc.) into the data table field. You then use a form or report, add a control for the picture, and reference the data table field as the underlying source for the control.

Please click the check mark next to my response if you believe it best answers your question.

edit flag offensive delete link

Comments

I don't think LO (at least with Firebird) gives the option of linking to a picture. The increase in the file size indicates that the image is inserted.

Pansmanser ( 2018-10-09 12:20:25 +0100 )edit

add a comment

Can you insert a picture into a database field. If so how ? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-01 15:32:30.411741

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Can you insert a picture into a database field. If so how ? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-09-01 15:32:30.411741

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Can you insert a picture into a database field. If so how ? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-01 15:32:30.411741