Ask Your Question

When making a query in base on a table from an ods file, I cann't define any fucntions to the queried fields

asked 2020-07-22 10:42:02 +0100

hermanv gravatar image

LibreOffice on Linux Mageia 7. Open a new database and choose an ods file as it source. One of the tables has a.o. a text and a numeric field. I cannot assign a group function to the text and sum function to the numeric field. When I write the proper sql myself I get "syntax failure", which is not really so. On a fierbird-based database, this all works OK.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-23 02:25:12 +0100

Ratslinger gravatar image


Please see my answer in this post -> Base: run query on connected spreadsheet?

edit flag offensive delete link more


I've read your recommendation and it makes sense, but I cann't use it straightaway, because the spreadsheet in question is daily conveyed to the community and each day it completely replaces the one from the previous day. But I'll be back on the subject, because you made me think about another possible (!!!) way out.

hermanv gravatar imagehermanv ( 2020-07-23 21:03:04 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-22 10:42:02 +0100

Seen: 43 times

Last updated: Jul 23