On 10/10/16 05:29 PM, Gary Dale wrote:
On 10/10/16 05:05 PM, Gary Dale wrote:
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....
Actually, it looks like any table I add is read only... The original
table in the database allows me to add and change records, but new
tables that I add don't.
Go it. The old primary key problem. Base insists that it create one and
call it ID instead of using another name.
--
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
