Formatting bug when using IIF

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Formatting bug when using IIF

Postby eugenen » Tue Nov 12, 2013 12:32 pm

if you take the following statement, the spaces are intenional white spaces, and format it it does not format the IIF as nicely as the datediff

Code: Select all
   iif(     rrbr.ColumnName = 'Test',    0,       1),
   datediff(       day,         getdate(),       getdate()    )
   recon.ReconResultsByRow as rrbr

   rrbr.ColumnName = 'Test',    0,       1),
   datediff(day, getdate(), getdate())
   recon.ReconResultsByRow as rrbr
Posts: 5
Joined: Tue Feb 23, 2010 11:13 am

Postby Aaron Law » Tue Nov 12, 2013 7:49 pm

This'll be fixed in the next release of prompt (and is also in the private build I mentioned on your other post)
Aaron Law
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests