Poor handling of OVER clause

Provides intelligent code completion for SQL Server editors.

Poor handling of OVER clause

Postby atompkins » Tue Sep 10, 2013 1:32 pm

6.1.0.27

I'm not very happy with the way that window functions are handled. It's been like this for quite a while now and as I'm using them more and more it's getting to be a bit of a hassle. I've even gone so far as to install another formatter.

It appears as soon as Prompt finds an OVER clause it ignores everything until it finds something it recognises. This causes lines to overrun. I don't see why this should be, even if the clause isn't supported you should still be able to insert line breaks where there is whitespace.

I usually format to 120 chars. Can I send you a query so that you can see what I'm talking about? I don't seem to be able to do attachments here.
atompkins
 
Posts: 14
Joined: Tue Jul 05, 2011 10:45 am

Postby Aaron Law » Tue Sep 10, 2013 2:46 pm

Hi,
You can send me an email with your test script in to aaron.law@red-gate.com.

Thanks,
Aaron.
Aaron Law
 
Posts: 406
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests