Comment Formatting
scotthibbs
Posts: 18
Looked in forum for similiar issue...did not find any. The Layout SQL function does not seem to handle comments effectively...such as:
Tried reformatting a second time.....no effect.
Is there an option to better handle comments?
IF @hr = 0 BEGIN -- Note that ExceptionStatus is set to 2. This is a flag to the message processor -- that this is a Work Status event. It is NOT the actual exception status. EXEC @hr = master..sp_OAMethod @objptr, 'SendTrigger', @return OUT, @TriggerText = @exceptionwoqueuetriggertext, @ExceptionId = @exceptid, @PID = @newupdatepid, @ExceptionStatus = 2, @DBName = @db, @Server = @server, @DeliveryQueueName = @exceptionwoqueuename, @DeliveryQueueLabel = @exceptionwoqueuelabelNote that comments do not line up.
Tried reformatting a second time.....no effect.
Is there an option to better handle comments?
Comments
In refactored code, the comments hang off to the left by about 10 spaces.
It seems that comments are not move to line up with the next code statement.
Very sorry about the lack of response, no excuses really, we should have spotted it. SQL Refactor ignores comments for the most part at the moment. Aligning comments in the Layout SQL feature is one of the more common requests we receive about SQL Refactor and therefore addressing this issue something we would like to do in future releases of SQL Refactor.
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd
Formatting the comments would make the product really valuable.
Hopefully thisd ends up on the new feature list soon........