[7.0] Sql Editor wish: wrapped indent

Can u accept this feature request?
http://synwrite.sourceforge.net/forums/viewtopic.php?f=17&t=351

(Same EControl engine, like sql editor)
Several good editors have it (UltraEdit and EmEditor)

Thank

I'm not sure I understand the requested feature. Can you provide a SQL specific example instead of generic text paragraph?

By the way, that SQL Assistant does auto-indenting for you based on SQL keyword anchors? for example, if you enter

	Code:
	-- ... some code here ... -- here comes an indented line SELECT blah...blah ... here you press Enter key and type keyword FROM FROM -- FROM appears indented to align with the SELECT. It works similarly for other keywords, column names and other elements as defined in code formatting rules in the Options. WHERE -- where is aligned too

Sql example:

Code:

procedure NNNNNN -- some procedure beginning, like in Oracle
select ............................................................................................... from .............................................................. where .............................................. and ................... group by ................................
select ............................................................................................... from .............................................................. where .............................................. and ................... group by ................................

These are 3 lines. Editor shld display wrapped parts (of lines 2/3) with indent, 10 spaces.

Alextp wrote:

Sql example:

Code:

procedure NNNNNN -- some procedure beginning, like in Oracle
select ............................................................................................... from .............................................................. where .............................................. and ................... group by ................................
select ............................................................................................... from .............................................................. where .............................................. and ................... group by ................................

These are 3 lines. Editor shld display wrapped parts (of lines 2/3) with indent, 10 spaces.

Something is not working for you there. I see a number of issues there, including code auto-formatting not working. Which database type are you connected to? which SQL Assistance type is selected in Options for that type? Are you using factory default options or custom?

- I not connected yet, offline
- I chosen "Code formatting style: None" to not kill leading spaces
- now I enter text, with leading spaces, long lines, and get:

For that to work with MS Assess you need to choose Code Assistant and some Formatting style in the Options, I recommend using T-SQL style as the closest.

MS Access is not a good test case. Please try this feature with other more advanced database servers.

"Formatting style" I need None, because i don't want to auto format text, I want it as I type, with leading spaces. And my wish allows to show my not formatted text - nice

	Alextp wrote:
	"Formatting style" I need None, because i don't want to auto format text, I want it as I type, with leading spaces. And my wish allows to show my not formatted text - nice

But this disabled the auto-indenting feature which is part of the code formatting. Unfortunately you cannot have it disabled and still working for auto-indenting only.

	Quote:
	But this disabled the auto-indenting feature

No, I checked "Auto-indent" in Editor op dialog, and it works OK here, even W/out "Code formatter" enabled

Glad you found s workaround.

Just in case, that one is not SQL syntax related. As compared to the SQL syntax based indenting, it won't indent joins, logical operators, sub-queries, etc... so you will need to type more, not less when code formatting is enabled.