SQL Stops correcting / working when I have a pivot.

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

SQL Stops correcting / working when I have a pivot.

Postby CrispinProctor » Wed Jun 16, 2010 12:04 pm

Hi Folks,

My sql prompt 4.0.3.12 seems to stop working when I have a pivot in my code.
Another "odd" thing that happens is scrolling with the arrow keys is slow, as is typing. Holding down shift and using the arrow keys makes the cursor stumble across without highlighting the code. When you stop, it seems to catchup and highlight everything.

Snippets also stop working.

If I remove the pivot, it's all good again. Code is not really large, it's only 68 lines long. Without pivot, I have had a couple thousand and it's fine.

Anyone else have this?

CHeers,
Crispin
CrispinProctor
 
Posts: 4
Joined: Mon Oct 12, 2009 3:47 pm

Postby Anu Deshpande » Thu Jun 17, 2010 1:13 pm

Thanks for your feedback, and sorry you found this issue.

I have reproduced the symptoms you reported and it seems that the presence of PIVOT or UNPIVOT will stop SQL Prompt working as you described.

I have logged this as a bug with SQL Prompt, and it will hopefully be fixed in a future release.

For your reference the bug tracking code for the issue is SP-2885.

The only workaround I can really offer for the time being, is to comment out the words PIVOT or UNPIVOT, as this seems to kick SQL Prompt into life again.

Thanks for taking the time to let us know about this.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby CrispinProctor » Mon Jul 05, 2010 1:07 pm

Thanks for the reply. I'll wait for an update.
CrispinProctor
 
Posts: 4
Joined: Mon Oct 12, 2009 3:47 pm


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests