Hi Harvey,
I am not using macros (yet...hmm). I create the queries with the GUI in SQL view. I execute using the 'Run Query (F5)' function from the editor. The SQL text is not allowed to be stored with the syntax error in the one case. In the case of the shorter command, the SQL text is stored as a query and, it seems, could be run from the GUI, if it weren't for the executeUpdate() error.
The query-editor will only work with queries, not with updates or inserts. You have to start the command through Tools > SQL in the Base-file.
The database itself is backend mariadb connectect via JDBC.
So you have to use UPDATE `Adressensammlung`.`Adressen` SET `Adressen`.`Print_flag` = TRUE WHERE `Adressen`.`Xmas` = TRUE; Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy