SQL Formatter Bugs?

[jasonboyd]

Couple of quick questions/observations. I do not know if I am missing something or if these are bugs. First things first, I am using a trial copy of dbForge SQL Complete, Standard Edition, version 4.8.43.1.

- In my formatting profile I have 'Add empty line after GO' checked. It does seem to do anything. There is no empty line after any of the 'GO' statements except the ones that were there prior to running the formatter.
- In this link you added a new option in version 4.5 to 'Enclose identifiers within square brackets []'. I cannot find that option anywhere. When editing a profile, if I enter 'square' in the search textbox, no results are found.
- The formatter seems to completely fall down when square brackets are involved. I have a SQL script where the datatypes are enclosed in square brackets and the formatter completely ignores the datatypes. No formatting whatsoever is applied to them.

Thanks.

[alexa]

- In my formatting profile I have 'Add empty line after GO' checked. It does seem to do anything. There is no empty line after any of the 'GO' statements except the ones that were there prior to running the formatter.

Could you please provide us the script and specify where you are expecting an empty line to be added?

Please note that by design a new line is not added if an empty line is already present or GO is followed by one of the following:

CREATE|ALTER PROCEDURE|FUNCTION|VIEW|TRIGGER

- In this link you added a new option in version 4.5 to 'Enclose identifiers within square brackets []'. I cannot find that option anywhere. When editing a profile, if I enter 'square' in the search textbox, no results are found.

This can be setup as follows:

1. Select 'SQL Complete -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Advanced' section.
3. Select the appropriate radio-button under the 'Enclose identifiers within square brackets' section.

- The formatter seems to completely fall down when square brackets are involved. I have a SQL script where the datatypes are enclosed in square brackets and the formatter completely ignores the datatypes. No formatting whatsoever is applied to them.

Could you please provide us the full script?