https://bugs.documentfoundation.org/show_bug.cgi?id=31398
--- Comment #9 from [email protected] --- Created attachment 124891 --> https://bugs.documentfoundation.org/attachment.cgi?id=124891&action=edit sample database for query testing status is still same as in comment#3 as of LibreOffice 5 Version: 5.0.6.2 Build ID: 5.0.6.2-3.fc23 (as in fedora package libreoffice-base-1:5.0.6.2-3.fc23.x86_64) 0) observation on comment#7 > - in Tools > SQL: "Command successfully executed" and result is good; > - in Query > Create a SQL Query: "Syntax error". > in order to get the query to save from sql view you have to select Edit-"Run SQL command directly" otherwise it wont let you save but just gives syntax error: SQL Status: HY000 Error code: 1000 Syntax error in SQL statement syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE 1) run the saved update query doesnt make any changes to table and still gives the error: The data content could not be loaded. SQL Status: 00000 Error code: -155 Statement does not generate a result set 2) input sql of update query into tools-sql-menu of main base window running the same sql code through the tools-sql-execute still works sets the true flagged records to be false flagged and gives no errors: 1: Command successfully executed. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
