#2132 SQL Formatting could use some enhancement

[Anonymous]

Originally created by: jason.fo...@gmail.com

What is the problem that needs to be solved (required)?

Heidi is a fantastic application, but the SQL formatting features are very basic. It would be great if there could be some very simple refinements.

What is the idea in abstract terms (optional)?

We need the following:
Line breaks after each select item
Indenting

Example workflow using the new feature (optional)?

See the attached comparison between heidi's sql formatting of a view and "Squirrel SQL Client"
Few things to notice:
1. There is a sub query in the select section and heidi treats it without any indentation making it very hard to read.
2. See how long the scroll bar is in heidi? it's impossible to find the field I need to edit.
3. Despite what I have been told CTRL+F Does not work on this screen
4. No indenting in the from query means I can't properly analyse the from area's of the query.

Now you might look and say why would I write such a rubbish query. The reason is that this is a "View" and as soon as you save a view, such as select * from table, mysql automatically expands that query to be the most ugly, specific and long winded query. that can't be fixed, but heidi can indent it though.

Thank you so much, Heidi is the BEST sql client for mysql out there today! hands down, no PC product comes even close. TOAD/Mysql Gui tools/workbench (what a p.o.s)/navicat (worst of the lot) etc can't hold a candle stick to heidi...

[Anonymous]

Originally posted by: a...@anse.de

I'm unable to add your wanted linebreaks and indentation. The code is somewhere between simple and complex, but not too much, only I'm constantly breaking something if I add linebreaks within desired if/else constructs.

Probably you can help out? Relevant code is in helpers.pas, function "ReformatSQL", line ~2535.

Status: WontFix