Wrapping not working

torsten.strauss

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

Tianjiao_Li

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!

Tianjiao_Li

Hi @torsten.strauss

Can you attach your format style file here so that I can reproduce it?

Which version of SQL Prompt did you use?

Thanks!

torsten.strauss

Hi Tianjiao,

I am always using the latest version

Please find the style sheet attached.

Thanks!

Torsten

Tianjiao_Li

Hi 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.

torsten.strauss

Hi Tianjiao,

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

Tianjiao_Li

Hi @torsten.strauss

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.