distal-attribute
distal-attribute
distal-attribute
distal-attribute

Option to turn off backticks

User, date Message
Written by mrforsythexeter
4 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
4 years ago
5023 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
4 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
4 years ago
5023 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
4 years ago
5023 posts since Fri, 07 Apr 06
Done in r3610.
Written by mrforsythexeter
4 years ago
26 posts since Wed, 24 Nov 10
Thank you
Written by kalvaro
4 years ago
595 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 wildhappy
Written by kalvaro
4 years ago
595 posts since Thu, 29 Nov 07
About my previous comment... It appears that you do this just fine:

SELECT date, year
FROM my_table



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.