SQL Complete formatting errors?

[jrobohn]

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

[alexa]

Hello,

Could you please provide us the following information:

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

[jrobohn]

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]

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]

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.