Re: [libreoffice-users] loading a database with images

On 10/10/16 03:38 PM, Robert Großkopf wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Gary,
> > SELECT "place"
> You have forgotten: ,
> SELECT "place", ...
> > CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN
> > 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3
> > THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon"
> > FROM "Results"
> With ' ' will be input text. It isn't an image, which could be shown.
> Save the images by a form in a separate table "images".
> You will get the image you want, if you start a subselect for it.
>
> SELECT "place",
> CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0)
> WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1)
> WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2)
> WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3)
> WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4)
> END AS "ribbon"
> FROM "Results"
>
> Regards
>
> Robert

Having an issue with my form. I was able to dump the ID data into it 
from a spreadsheet (paste into the table) but the table seems to be read 
only. When I right-click on the image control, nothing happens. I also 
have an extra field which provides a text translation of what the image 
says and I can't modify it either.

I was following a video by TheFrugalComputerGuy.com -

LibreOffice Base (15) Embedding a Picture and things went pretty much as 
per his video in the very short bit about actually adding the control, 
but it doesn't let me edit.

There's probably something about Forms that I'm missing....


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted