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

SQL Formatting

User, date Message
Written by jason.fonsecaMoney, Euro
4 years ago
Category: Feature discussion
7 posts since Fri, 06 Aug 10
Hello,

When I look at the code for a view the SQL is formatted is it should be straight from the mysql database. It looks terrible.

Can you consider the following features
1. Enable the "ctrl+f" in that view screen
2. Enable the source formatting in that view screen

With the source formatting, can you please have an option to put each SELECT field on a new line? something so simple as this would make a view's sql much much more readable. The sql goes on for ages and even wordwrap can't make it more pretty. Just need a new line after each comma.

Thank you so much, heidi sql is fantastic software !
Written by ansgar
4 years ago
5015 posts since Fri, 07 Apr 06
SQL reformatting is already implemented - Ctrl+F8 is the default shortcut. Works in the view code editor, as well as in all other SQL editors.
Written by jason.fonsecaMoney, Euro
4 years ago
7 posts since Fri, 06 Aug 10
Unfortunately the sql formatting falls well short to format a view from mysql. See here: http://bugs.heidisql.com/2132

Also Ctrl+f doesn't work in the view screen.

I would love to see this improved as heidi is such a fantastic application
Written by jason.fonsecaMoney, Euro
4 years ago
7 posts since Fri, 06 Aug 10
That link again:
http://bugs.heidisql.com/2132
Written by ansgar
4 years ago
5015 posts since Fri, 07 Apr 06
Reasonable: r3496 enables the search + replace dialog for all SynMemo's, including the VIEW editor.

Formatting should be discussed in issue #2132.
Written by jason.fonsecaMoney, Euro
4 years ago
7 posts since Fri, 06 Aug 10
Wow, thank you! excellent support. much appreciated.
 

Please login to leave a reply, or register at first.