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: [email protected]
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
