Using the "Edit in SQL View", OpenOffice modifies the query when saving it.
For example, I write
SELECT myAttribute from myTable
and test it in the SQL Tool, I get this message:
1: Command successfully executed.
Back to "Edit in SQL View", I save my query, close it, and re-open it in "Edit in SQL View", and now my query looks like this:
SELECT 'myAttribute' from 'myTable'
which gives me this message when I test it in the SQL Tool:
2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Benevole'' at line 1
That was not an issue when I was using the OOBase interface with the HSQLDB engine, but I'm now using the MySQL engine, and this single-quote symbols syntax is not supported.
I do I tell OpenOffice not to add these single-quote symbols in the query when saing it?
Thanks!