SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-02-09 15:12:09

damuchi
Member

SQL Formatter | Does not work like expected

Hello

Im using the following settings in SQL Formatter.

Line Breaks
- Before comma
- Before AND/OR
- After (SELECT ...)

Block Style
- Style 1

Spaces | Operators
- A = B + C

Spaces | Lists
- A, B, C

Spaces | Braces
- count(A)

But this doest not work anymore since about one year.

Original SQL

SELECT v100.aufnr FROM v100 WHERE v100.vvorgart = 2    AND v100.fi_nr = 1 AND v100.datneu < getdate () -100 AND (v100.datbis < getdate () -10  OR v100.datbis IS NULL)    AND v100.ang_stat = 20

Result with SQL Formatter

SELECT
v100.aufnr
FROM
v100
WHERE
v100.vvorgart = 2 AND v100.fi_nr = 1 AND v100.datneu < getdate () -100 AND (v100.datbis < getdate () -10 OR v100.datbis IS NULL) AND v100.ang_stat = 20

Expected Result

SELECT
    v100.aufnr 
FROM
    v100 
WHERE
    v100.vvorgart = 2
    AND v100.fi_nr = 1
    AND v100.datneu < getdate () -100
    AND (v100.datbis < getdate () -10  OR v100.datbis IS NULL)
    AND v100.ang_stat = 20

Thank you for your support.

DaMuchi

Offline

Board footer

Powered by FluxBB