How can we help you today? How can we help you today?

Problem with square brackets in SQL Prompt 6.5.0.326

SQL Prompt 6.5.0.326 does not appear to honor my choice regarding adding or removing square brackets.
My option setting on the Format>Actions page has the "Add/remove square brackets" checkbox blank. I assume that means to make no change to any square brackets.

However, when I format a simple query 
DELETE sts FROM [dbo].[ScheduleTimeSlots] sts INNER JOIN [dbo].[Schedules] s ON s.ScheduleId = sts.ScheduleId WHERE s.ScheduleJobId = 22

I receive 
DELETE  sts
FROM    dbo.ScheduleTimeSlots sts
INNER JOIN dbo.Schedules s ON s.ScheduleId = sts.ScheduleId
WHERE   s.ScheduleJobId = 22

The layout for spacing and line breaks is expected, but I did NOT expect the square brackets to be removed.

What setting must I use to have SQL Prompt leave square brackets alone?
weswinkler
0

Comments

3 comments

Sort by
  • Aaron L
    Hi weswinkler,

    Do you have "Qualify object names" ticked under format actions? Before we added a separate feature for enclosing all identifiers in brackets in 6.5 this was a pretty common way to add or remove square brackets.

    Now that we have both add and remove square brackets as separate features we plan on changing qualify object names so it will preserve the existing brackets. Sorry that this hasn't been implemented yet!

    Thanks,
    Aaron.
    Aaron L
    0
  • weswinkler
    Yes, I had "Qualify Object Names" ticked/checked.

    When I uncheck that option, the square brackets behave as expected.

    But, I still wish the interaction between the two could be separated.

    I like having the objects qualified; in fact I need it sometimes when working with objects in a non-dbo schema. I just don't want SQL Prompt to mess with square brackets unless I explicitly ask for it.

    I hope this is resolved in a future release.
    weswinkler
    0
  • KimN
    This is still an issues as of version 9.2.2.5855. Any plans to separate the logic of "Qualify object names" and "Add and remove square brackets"? It would be appreciated.
    KimN
    0

Add comment

Please sign in to leave a comment.