Remove Brackets no longer functions like it used to - 10.0.10.13591

• 
  Hello Doug!

  Thanks for your inquiry and sorry to hear about your issue with SQL Prompt. I can confirm that I was able to replicate this issue on my end and I'll be sure to forward this over to the developers for further analysis. I'll be sure to get back to you with their thoughts.
  

  squigley January 30, 2020 23:58

  - 0 +
• 
  Excellent - RG Rocks!

  Ozzie January 31, 2020 14:40

  - 0 +
• 
  Hello Doug,
  I was able to go back and forth with the developers on this. They've found that the issue only seems to occur if its just the list of columns. It works as expected when you expand it into a full SQL statement.
  
  For example:
  [EmployeeID],[ManagerID],[Gender]
  becomes
  EmployeeID,[ManagerID],[Gender]
  
  whereas 
  
  SELECT [EmployeeID],[ManagerID],[Gender] FROM HumanResources.Employee AS e
  becomes
  SELECT EmployeeID,ManagerID,Gender FROM HumanResources.Employee AS e
  
  Can you confirm if you're seeing this happen with statements on your end as well or just as a list of columns?
  
  Thanks!
  
  

  squigley February 04, 2020 17:30

  - 0 +
• 
  That is exactly what I see - but I use this all of the time - seems like an easy fix.

  Ozzie February 05, 2020 14:31

  - 0 +
• 

  Hello Doug,

  I was able to get further details from the developers on this and unfortunately they aren't able to dedicate time to fix this at the moment.
  

  If SQL Prompt is provided a script that is not close enough to a SQL query then we cannot ensure that it will be able to figure out what syntax elements the text represents, and thus formatting actions will not always be as desired.
  
  The suggested workaround would be to add enough syntax so that Prompt can understand what the list of columns are intended to represent similar to what was mentioned in the last post. I.e., instead of running "Remove square brackets" on
  
  

  [a], [b], [c]
  

  You could add text to make the script read
  

  select [a], [b], [c] from x
  

  and then run "Remove square brackets", which should remove the brackets as desired.

  
  

  Apologies again that there isn't a more straightforward fix at the moment, but I hope this helps.
  

  
  

  Thanks!
  

  squigley February 13, 2020 00:08

  - 0 +

Add comment

Please sign in to leave a comment.