search

AbeEstrada / atom-format-sql

https://atom.io/packages/format-sql
MIT License
5 stars 4 forks source link

Format returns error, and do nothing #2

Open marcos-mestre opened 10 years ago

marcos-mestre commented 10 years ago

Trying to format the following sentence: INSERT INTO sw_merchants_ws_methods(sw_merchants_id, sw_webservice_methods_id) VALUES ('ap_inv', 'Authorize_2p'); The console returns: Error {} -> format-sql.coffee:28

Atom version 0.106.0-781a51a Format Sql version 0.1.1 SO Ubuntu 14.04. Thank you.

AbeEstrada commented 10 years ago

I chose a not so good sql parser (https://github.com/forward/sql-parser), I'm going to search another one and replace it.

marcos-mestre commented 10 years ago

Thank you.

Marcos Mestre

nbering commented 10 years ago

I'm encountering the same issue on this query.

select count(*) from Accounting where Not CreditAccount = '' Or Not DebitAccount = ''

Is there a work-around? I'd like to use this as I've got a whole bunch of queries captured from a profiler tool that I need to analyze.

ianwalter commented 9 years ago

@AbeEstrada Do you think this pull request would fix the problem? https://github.com/forward/sql-parser/pull/4 You could always try using his fork instead of master.