Version 2025 - Format Code

[anhe]

How code a SQL like below cannot be formatted by using Format Code (Ctrl+Shit+F)

Worked in version 16

My opt file is identical

SQL

SELECT artno, artname FROM tas_art WHERE artno LIKE '1%';

Should be formatted to:

SELECT artno, artname
FROM tas_art
WHERE artno LIKE '1%';

[mstaszew]

I see the same default formatting in 16.0 and 2024 R2.

16.0

2024 R2

I think you want this option set.

[anhe]

Hello,

believe me. I have tried all settings

It works if only one column is present in the SELECT part

[mstaszew]

I missed that you were using 2025 R1. I have tested there and see the same as before.

Please go to Help | Support Bundle and grab all of that text and email it to me along with your FmtPlus.opt file from 2025 R1 and I'll try with your same settings. michael.staszewski@quest.com.

Michael

[mstaszew]

Thanks for the email. I can reproduce the issue with your settings. The reason is the default list setting. You have it set to "Tabular." The default value, "Stacked on Overflow or More than..." works. You can hover over the control and read the hint for more information about each setting. With that setting set to Tabular, I can reproduce what you see and I see consistent behavior in older versions as well with this option set. This may be expected behavior. I'll reach out to the Formatter developer for clarification.

[anhe]

Arh Ok.

I have changed to Wrapped and changed the Margin to 200. That helped a bit

[mstaszew]

@anhe

@mstaszew

This may be expected behavior. I'll reach out to the Formatter developer for clarification.

This is not expected. A defect has been logged.

Thanks,
Michael