On 24/05/20 8:39 AM, Skip Montanaro wrote:
May I ask why not simply like this: stmt = """ select foo from bar where a = 'bag' and c = 'dog' """Sorry, I don't recall. I wouldn't be at all surprised that it has something to do with Emacs's Python mode behavior. Emacs wouldn't know what to do with spaces in the string, but knows where to put string literals within the open parens. I'm pretty sure I was doing this before triple quoted strings existed. Thankfully, I don't need to mess around with SQL anymore. :-)
Awwww. don't be like that - send it all to me, and I'll fix it for you (at exorbitant rates, of course)...
The above is valid - the editor has a file in one format/language, and is therefore applying 'the wrong rules' when it attempts to make SQL look like Python!
The inconvenience (cf "issue") that arises, is that many SQL debuggers and error-handlers (etc) will repeat-back the source-code/query as-provided. Consequently, those messages are all messed-up with extraneous tabs and new-lines, making them difficult to read and debug.
(see also: earlier post mentioning separation of languages/code) -- Regards =dn -- https://mail.python.org/mailman/listinfo/python-list
