How to insert a link to an odb database to display an image
I'm trying to create hyperlinks into a database I'm creating of plants and herbs (odb). But it doesn't work.
First time here? Check out the FAQ!
I'm trying to create hyperlinks into a database I'm creating of plants and herbs (odb). But it doesn't work.
Here is a minimal setup.
First the table. Two fields: an ID for key (AutoValue = Yes) and a Text[VARCHAR] of say 100 characters to hold the location.
Next the form. Form properties set to the created table. Two controls on the form: Image Control pointing to the text field in the table and a Navigation Bar to move through the table items.
To use, open the form. With no records in the table you can add a new link by a right mouse click on the image control, then left click on the displayed Insert image from...
and select the location of the wanted image. Go to Next Record
and the previous link is inserted into the table.
I tried Ratslinger's answer. It works very well. Here a example with flags:
@charlie.it thanks for the sample. Works fine if .png samples and saved paths match. Even without that, it allows for new entries to be made.
Today I followed another way: link rather than embed the images, so that the odb file can remain of small size.
1. in edit view add a text box in your form and
2. convert it (replace with) to a image control
3. in normal view double click on the new box and select the image, which will not embedded, but linked.
If you use a mysql database you can set the field as varchar (at least 150 char) and insert the location, such as http://localhost/your-path/yourfile.jpg
Asked: 2016-08-31 15:43:27 +0100
Seen: 1,857 times
Last updated: Sep 28 '19
How can I use a check box in a Base report to indicate a binary value? [closed]
How to make LibreOffice Base reconnect to a database [closed]
Retrieving primary key id from a Combo Box? [closed]
How can I hide the information_schema and pg_catalog tables? [closed]
CREATE DOMAIN in Base? [closed]
Possible to update primary key on delete in Base? [closed]
Are there any plans to improve image handling? [closed]