Option to turn off backticks
| User, date | Message |
|---|---|
|
Written by mrforsythexeter
2 years ago Category: Feature discussion 26 posts since Wed, 24 Nov 10 |
It would be nice to have an option to turn off back ticks when dragging a column / table etc. into the query unless a space or SQL reserved word is found. I feel the back ticks make the code harder to read, and currently the SQL syntax highlight represents them as a string colour rather than an object. |
|
Written by ansgar
2 years ago 3958 posts since Fri, 07 Apr 06 |
Sounds not too bad. Only I guess now you're talking about the column list, tomorrow you request some other function where backticks are added, and so on. Right? |
|
Written by mrforsythexeter
2 years ago 26 posts since Wed, 24 Nov 10 |
Sorry I have posted a lot of stuff, as I said before.. trying to make the jump from MySQL-Front. It added these back ticks and it really made a mess of clean looking code. If you open a view which has been formatted by Mysql, you will know that the fog created by all the back ticks makes it hard to read. So it was just an idea. Sorry. |
|
Written by ansgar
2 years ago 3958 posts since Fri, 07 Apr 06 |
No need to be sorry, really. I'm just a bit overextended by about having 10 open questions with mixed feature requests and bug reports at one time, while my kids are setting my bathroom under water and an ill wife asking me to bring her some medicine. However. I think TMySQLConnection.QuoteIdent could get some more intelligence with a third parameter "AlwaysQuote". |
|
Written by ansgar
2 years ago 3958 posts since Fri, 07 Apr 06 |
Done in r3610. |
|
Written by mrforsythexeter
2 years ago 26 posts since Wed, 24 Nov 10 |
Thank you |
|
Written by kalvaro
2 years ago 441 posts since Thu, 29 Nov 07 |
I didn't really notice how much I missed this feature until I saw it implemented. Thank you very much, Anse! A little detail: you must also check whether the identifier is a reserved word, e.g. a date column called `date`. **I** don't do such things but it can happen in the wild 
|
|
Written by kalvaro
2 years ago 441 posts since Thu, 29 Nov 07 |
About my previous comment... It appears that you do this just fine: SELECT date, year I'm sure there was a case when quoting was necessary but I can't remember which one. |
|
Please login to leave a reply, or register at first. |