search

sqlparser / isf_notepad

SQL Formatter plugin for Notepad++
Apache License 2.0
77 stars 47 forks source link

Formatter in Notepad++ formats differently from online Oracle formatting #12

Open onejude opened 4 years ago

onejude commented 4 years ago

How do I get the Oracle formatting that I can choose online?

akinet commented 4 years ago

From this page: https://github.com/sqlparser/isf_notepad You can read

You can also download format option file and put it into Notepad++\plugins\Config\sqlformat. You can change options in this file to control the layout of formatted sql.

For detailed explanation of those format options, Please check document here:

https://github.com/sqlparser/sql-pretty-printer/wiki/SQL-Coding-Standard-and-Guideline

Mile140 commented 4 years ago

i downloaded the fo.json file and placed it into the Config/sqlformat folder. I make changes to the format options file but they don't seem to do anything. It just keeps changing the SQL format to the default settings.

desinxq commented 4 years ago

Is there a new guide on how to install then options file on the latest notepad++. I have notepad version 7.8 and I also cannot get the options to work as per the documentation.

I created a folder \Program Files (x86)\Notepad++\plugins\sqlFormat and put sqlFormat.dll file there, and that works without issues.

I also created a folder \Program Files (x86)\Notepad++\plugins\Config\sqlformat and put the options file fo.json in that folder.

I can get the default formatting to work but if I edit the json file options, they don't reflect on formatted code, even after restarting notepad++.

I'm I missing a step?