Hi, Thanks to your code.

I'm install to my notepad++

select id from TableName

this will change

SELECT id
FROM   TABLENAME 

but I got error.

Table 'TABLENAME ' doesn't exist

windows is OK but in linux i got error.
i think that talbe name has 'case sensitive' in linux

I am using v1.01 of the formatter in NP++ v6.7.5 on windows 8.1.

When I try to use the formatter for the following line of SQL it does nothing whatsoever – though if I run it through your website formatter it formats perfectly.

SELECT TOP 5000 n.name_id, COALESCE(n.e_mail_address,'') as Email_address, COALESCE(n.title_code,'') as Title_Code, COALESCE(n.first_name,'') as First_Name, COALESCE(n.last_name,'') as Last_Name, n.ok_to_email, n.ok_to_sell_name,a.country_id,(MAX(li.update_dtm)) as Last_Purchase_date,(COUNT(DISTINCT li. order_number)) as Number_Of_purchases,COALESCE(n.promotion_id,'') as Promotion_Id,SUM(li.product_price) AS Life_time_spend FROM line_item li WITH(nolock) INNER JOIN names n WITH(nolock) ON li.name_id=n.name_id INNER JOIN Addresses A WITH(Nolock) on li.address_id=a.address_id INNER JOIN Orders o ON o.order_number = li.order_number WHERE n.company_id IS NULL AND li.parent_sku IS NULL AND o.Catalog_id NOT IN ('12516','STAPLES','12502','EZIBUY','EZIBUYNZ1','32211','12821','42114','JDWUK','JDWIRE','UKWHOL40','32537','32538','SKYMALL','CUTEKID','11125','11123','US208','UKWHOL40',) AND coalesce(n.e_mail_address,'') <>'' GROUP BY n.Name_id, n.e_mail_address, n.title_code, n.first_name, n.last_name, n.ok_to_email, n.ok_to_sell_name, n.promotion_id, a.country_id ORDER BY Life_time_spend DESC

Even if I try to format some really simple SQL such as the following it still does nothing:

select * from table1 where surname = 'smith' and age > 50 order by cust_id

I have also tried removing the fo.json file from the plugins/config/sqlformat folder in case that was causing the issue but it made no difference.

When i select the SQL and use SQL format context menu I get error as below

Input SQL is empty!

I choose format and nothing happens. Whether I select the text or not. I am online. Using Notepad++ 6.9.2

Hi. I am able to select sqlformat from the plugins menu in notepad++ but it doesn't format/change any of the code like it was able to do so yesterday. I looked through the Q&A in github isf_notepad++ - The plugin is a .DLL so the command "where.exe sqlformat" wont find it anyway. I have not made any configuration changes or updates to my machine. What do I do to fix this please?

When I am formatting a big document and I change to another document before formatting is finished, formatted text is inserted in the last document.
I suppose the plugin should remember the document where it was invoked to return their results to that document instead to return to the focused document.

Regards.

I have updated npp to 7.7.1 version, copied the sqlFormat.dll to then C:\Program Files (x86)\Notepad++\plugins:

and configured the menu

but the menu still doesn´t showing after reboot npp

I put a download format option file in the file path as written in the GitHub manual, but it doesn't work.

Of course, sql formatter works as a default option, but what I want is an alignment option that the user has changed.

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

If I set fmt044_insert_column_list_start_parenthesis_in_newline to false I expect to have output of this kind:

INSERT INTO SALES.saleshistory (salesorderid,
                                salesorderdetailid,
                                carriertrackingnumber,
                                modifieddate)                   
SELECT * 
FROM SALES.salesorderdetail;

but I am receiving this:

INSERT INTO SALES.saleshistory
            (salesorderid,
             salesorderdetailid,
             carriertrackingnumber,
             modifieddate)
SELECT *
FROM   SALES.salesorderdetail; 

Example in https://github.com/sqlparser/sql-pretty-printer/wiki/Insert-statement shows that combination of options:

• fmt040_insert_column_list_style = stacked
• fmt044_insert_column_list_start_parenthesis_in_newline = false
• fmt048_insert_column_list_first_column_in_newline = false

generates the output I am expecting.

What is wrong? Is there any other option I need to set to get the expected output?
Regards.

none option of fmt019_where_condition_andor work

the result is always the same

SELECT PD.CODICE,
HD.NUM_PROGRESSIVO,
HD.DATA_REGISTRAZIONE,
*
FROM DOCUMENTO HD,
RIGA_DOCUMENTO RD,
PROF_DOCUMENTO PD
WHERE PD.ID_PROF_DOCUMENTO = HD.ID_PROF_DOCUMENTO AND
RD.ID_DOCUMENTO = HD.ID_DOCUMENTO;