Start a new topic

Formatting of statements with DECLARE keyword

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

I've noticed weird formatting of SQL statements with DECLARE keyword (using SQL Server). As if they mark some beginnig of statements block. Tried differnet formatting options but nothing could change that weird indentation and line breaks. Please, see an attachment how these statements DbVis formats: bq. DECLARE @ErrorNumber INT \\ DECLARE @ErrorSeverity INT \\ DECLARE @ErrorState INT \\ DECLARE @ErrorProcedure NVARCHAR (128) \\ DECLARE @ErrorLine NVARCHAR (128) Used DbVis v9.1.5 on Windows 7. I'm not sure, maybe I'm missing something?

[This reply is migrated from our old forums.]

Re: Formatting of statements with DECLARE keyword
Hi, This is SQL Server specific syntax, so you need to tell the formatter about it. You do so in Tools->Tool Properties, in the General/SQL Commander/SQL Formatting category. Set Source SQL to SQL Server and it will not indent the DECLARE statements. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Formatting of statements with DECLARE keyword
Dear Hans, thank you! That option indeed helped.