How is SQL Prompt helping your team? Share your experience.
Wrapping not working
torsten.strauss
Friend of Redgate › Posts: 259 Silver 3
in SQL Prompt
Hi Redgate Team,
the following statement is longer than 80 chars but even so wrapping is not working.
CREATE TABLE on_disk_table ( col1 integer NOT NULL IDENTITY, col2 char(8000) NOT NULL );
I set Wrap lines longer than 80 in Wrapping / Whitespaces.
Thanks for looking into this!
Torsten
MVP
Tagged:
Best Answer
-
Tianjiao_Li
Posts: 684 Rose Gold 5
Hi @torsten.strauss
I can see your point! We've logged this issue as SP-7321 in our internal bug tracking system. I'll keep you posted!
Answers
Can you attach your format style file here so that I can reproduce it?
Which version of SQL Prompt did you use?
Thanks!
Tianjiao Li | Redgate Software
Have you visited our Help Center?
Torsten
Thanks for the style file. It appears the "Collapse parentheses if contents are shorter than ** characters" option prevails the longer than 80 in Wrapping / Whitespaces option.
If you uncheck it, it should work as expected.
Tianjiao Li | Redgate Software
Have you visited our Help Center?
thanks for your reply.
It works but I loose the control about the max char within the parentheses.
So is this a bug you are going to fix or is this option some kind of useless.
Thanks!
Torsten
Thanks for your patience with this issue.
Sorry we still haven't fixed the bug. The dev team has closed it as it's part of our road map to improve this area. So please keep an eye on the release note and the behaviour should be improved in the near future.
Tianjiao Li | Redgate Software
Have you visited our Help Center?