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

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