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

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.


--
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