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
SQL Complete formatting errors?
SQL Complete formatting errors?
Last edited by jrobohn on Tue 07 Feb 2012 13:51, edited 1 time in total.
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.
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.