SQL Formatting

[expired user #5084]'s profile image [expired user #5084] posted 14 years ago in Feature discussion Permalink
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 !
ansgar's profile image ansgar posted 14 years ago Permalink
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.
[expired user #5084]'s profile image [expired user #5084] posted 14 years ago Permalink
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
[expired user #5084]'s profile image [expired user #5084] posted 14 years ago Permalink
That link again:
http://bugs.heidisql.com/2132
ansgar's profile image ansgar posted 14 years ago Permalink
Reasonable: r3496 enables the search + replace dialog for all SynMemo's, including the VIEW editor.

Formatting should be discussed in issue #2132.
[expired user #5084]'s profile image [expired user #5084] posted 14 years ago Permalink
Wow, thank you! excellent support. much appreciated.

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