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

On 10/10/16 02:56 PM, Gary Dale wrote:
> I have a database with a large enough number of records that I don't 
> want to do this manually. I would like to have query do it instead. 
> Everything I've found through searches seems to want to do it manually 
> by creating a form.
>
> I have a small number of images (5), one of which will be added to the 
> database based on the content of another field.
>
> What I was thinking was something along the lines of (extra fields 
> omitted)
>
> 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"
>
> However I have two issues with that. The first is that the "Ribbon" 
> field probably won't contain the image from the current directory but 
> will instead just contain the text. The other is that Base complains 
> about a SQL syntax error when I try to save it.
>
> Can anyone help me move forward on this?
OK, missing comma after the first field explains the syntax error. But 
as expected, I'm getting the file name rather than the actual file in 
the query result.

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