Formatting Problem/Suggestion
aaronkool29
Posts: 3
I would like to have the formatting so the Type is lined up. I would also like the = to be lined up when I do a select
DECLARE
@lProcedureName VARCHAR(100),
@lReturnCode INTEGER,
@lValue INTEGER
SELECT
@lProcedureName = 'TestProcedure,
@lReturnCode = 0,
@lValue = 1234
Changed to the Following *(Note the Periods are just for Formatting on this post, those would appear as spaces in SQL)
DECLARE
@lProcedureName .VARCHAR(100),
@lReturnCode .......INTEGER
@lValue .................INTEGER
SELECT
@lProcedureName. = 'TestProcedure,
@lReturnCode....... = 0,
@lValue................. = 123
Some of the procedures I use anywhere from 5 to 50 Parameters and when they are squeezed together it gets very hard to read. I would like to have it format it all in line to make it easier. The other big problem I have is once I have all the Declarations & = lined up when I run the SQL Refractor it screws up all my formatting. Thanks.
DECLARE
@lProcedureName VARCHAR(100),
@lReturnCode INTEGER,
@lValue INTEGER
SELECT
@lProcedureName = 'TestProcedure,
@lReturnCode = 0,
@lValue = 1234
Changed to the Following *(Note the Periods are just for Formatting on this post, those would appear as spaces in SQL)
DECLARE
@lProcedureName .VARCHAR(100),
@lReturnCode .......INTEGER
@lValue .................INTEGER
SELECT
@lProcedureName. = 'TestProcedure,
@lReturnCode....... = 0,
@lValue................. = 123
Some of the procedures I use anywhere from 5 to 50 Parameters and when they are squeezed together it gets very hard to read. I would like to have it format it all in line to make it easier. The other big problem I have is once I have all the Declarations & = lined up when I run the SQL Refractor it screws up all my formatting. Thanks.
Comments
Thanks for the suggestion. No current combiantion of settings can make Refactor do these things, so we'll consider it for a future version.