Again code formatting

Hello,

I have problem with code formatting tool
here is the source code

	Code:
	DECLARE @aMonth int, @bMonth int, @cMonth int set @aMonth = (select a_code from spr_month where a_id = 1) set @bMonth= (select a_code from spr_month where a_id = 2) set @cMonth= (select a_code from spr_month where a_id = 3)

code after formatting

	Code:
	DECLARE @aMonth int, @bMonth int, @cMonth int SET @aMonth = (SELECT a_code FROM spr_month WHERE a_id = 1) SET @bMonth= (SELECT a_code FROM spr_month WHERE a_id = 2) SET @cMonth= (SELECT a_code FROM spr_month WHERE a_id = 3)

the problem is that the code after the ")" don't start from the beginning

another problem
source:

	Code:
	SELECT * FROM aaa INNER JOIN bbb ON aaa.a = bbb.b AND (aaa.a = 1 OR aaa.a = 2) INNER JOIN ccc ON ccc.c = aaa.a

formatted:

	Code:
	SELECT * FROM aaa INNER JOIN bbb ON aaa.a = bbb.b AND (aaa.a = 1 OR aaa.a = 2) INNER JOIN ccc ON ccc.c = aaa.a

your tool add empty line between join's, and if i do format again it will be two empty lines...

Sorry, i have bad English =(

SQL Assistant v 3.5.21

select template

	Code:
	SELECT ... AS ..., ... = ..., ( ... ) FROM ... AS ..., ... JOIN ... ON ... ON ... = ... AND ... OR (...) WHERE ... = ... AND ... OR (...) GROUP BY ..., ... HAVING ..., ... ORDER BY ..., ...

This looks like an issue with code formatter. For some reasons it treats consecutive SET = (query) as if they were subqueries. I am going to submit this issue to our bug tracking system. Hope it will be fixed in one of the following maintenance releases

Last edited by SysOp on Thu Jul 03, 2008 9:32 am; edited 1 time in total

Thanks,
what about the second problem?

I submitted that too. I think that empty line is caused by the expression in brackets and line wrapping, not by the second INNER JOIN.

The second join was added just to show new empty line =))
Thanks a lot