Devart Forums

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

Hello,

Could you please provide us the following information:

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

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.

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.

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.