Ask Your Question
0

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

hermanv gravatar image

LibreOffice 6.4.4.2 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
0

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

Ratslinger gravatar image

Hello,

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

edit flag offensive delete link more

Comments

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 42 times

Last updated: Jul 23