Hi Harvey,
I am accessing a backend Mariadb V10 on a backend server via MySQL(Native). The Base query contains only the following statement: UPDATE Family.Adressen SET Print_flag = FALSE; LO Version 5.3.5.2 from OpenSuse on Linux.
Have tested this with nearly the same configuration (OpenSUSE 42.2, LO 5.4.3.2 and native connector). You are right. It's possible to send an update to MariaDB whitout any error-message. Have tested the same with JDBC-connection to MariaDB. There it is impossible to send an update. You get the message ... Can not issue data manipulation statements with executeQuery() ... It has never beeen intended that the query-editor is used for changing data. There is a feature-request for this: https://bugs.documentfoundation.org/show_bug.cgi?id=31398 since 7 years. The risky feature is: the native connector of MySQL will allow this at this moment. If we write a bug-description about this the solution at this moment could be the "feature" of the direct connection will be taken away instead of changing something in the GUI, which works right with internal Database and other external connectors. 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/ All messages sent to this list will be publicly archived and cannot be deleted