(LibreWriter/Libre Base) DataSource in Writer won't sync to Base

asked 2018-09-28 14:52:55 +0100

updated 2018-09-28 14:54:10 +0100

Hello! I am trying to create a .odt file that contains some values from an SQL server.

I connected to the SQL server using Base and created a specific SQL query that returns one row of data.

Then in Writer I used Data Source (Ctrl+Shift+F4) to find my Base file, and that specific query. The data looked good from inside Writer, so I then just pulled my query towards the file and created a field (<weight> in my test). image description image description

The problem is that although the first value <weight> takes is always correct, it then NEVER syncs up to changes in the DB. The changes are visible from Writer in the Data Source window, but they don't sync up. F9 does nothing, and I am at my wits' end.

I'd appreciate any help in this matter and excuse the Greek characters!

EDIT: I'm so sorry for the Greek characters, "Ερώτημα 1" (which is higlighted in the first pic) stands for query1!

edit retag flag offensive close merge delete