SQL Complete formatting errors?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
jrobohn
Posts: 4
Joined: Fri 23 Dec 2011 14:29

SQL Complete formatting errors?

Post by jrobohn » Mon 06 Feb 2012 16:59

Hello,

Given the following (nonsensical) code block:

set @programfk = REPLACE(RTRIM(@programfk),'"','')
set @programfk = RTRIM(@programfk)
set @programfk = REPLACE(@programfk,'"','')
set @programfk = LTRIM(@programfk)
set @programfk = SUBSTRING(@programfk,2,8000)
set @programfk = STR(@programfk,2,8000)
set @StartDate = GETDATE()
set @StartDate = CONVERT(VARCHAR(10),GETDATE(),101)
set @StartDate = DATEDIFF(MONTH,IntakeDate,GETDATE())

after running format document, I get:

set @programfk = REPLACE(RTRIM(@programfk),'"','')
set @programfk = RTRIM(@programfk)
set @programfk = REPLACE(@programfk,'"','')
set @programfk = LTRIM(@programfk)
set @programfk = substring(@programfk,2,8000)
set @programfk = STR(@programfk,2,8000)
set @StartDate = GETDATE()
set @StartDate = convert(varchar(10),GETDATE(),101)
set @StartDate = datediff(month,IntakeDate,GETDATE())

My settings dictate that all keywords be made lower case. Clearly, most of the keywords were not affected by the format document operation.

Is this a bug or any there some other settings that I don't have set correctly?

Thanks,
Jay
Last edited by jrobohn on Tue 07 Feb 2012 13:51, edited 1 time in total.

alexa

Post by alexa » Tue 07 Feb 2012 09:20

Hello,

Could you please provide us the following information:

- product version
- product edition (Express, Trial, or Standard)

jrobohn
Posts: 4
Joined: Fri 23 Dec 2011 14:29

Post by jrobohn » Tue 07 Feb 2012 13:43

Well, I've tried this with 3.5.51 Standard and 3.1.28 Standard, but both of my dev machines have 3.5.51 now.

alexa

Post by alexa » Tue 07 Feb 2012 15:56

Thank you for the reply.

We were able to reproduce the issue and will fix it in one of the next builds of dbForge SQL Complete.

alexa

Post by alexa » Wed 22 Feb 2012 16:56

Hello,

We would like to let you know that the issue is fixed in the new version 3.5.54 of dbForge SQL Complete that is already available for downloading: http://www.devart.com/dbforge/sql/sqlco ... nload.html

Thank you for your help in improving dbForge SQL Complete.

Post Reply