Red Gate forums :: View topic - SQL Stops correcting / working when I have a pivot.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

SQL Stops correcting / working when I have a pivot.

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
CrispinProctor



Joined: 12 Oct 2009
Posts: 4

PostPosted: Wed Jun 16, 2010 12:04 pm    Post subject: SQL Stops correcting / working when I have a pivot. Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Thu Jun 17, 2010 1:13 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
CrispinProctor



Joined: 12 Oct 2009
Posts: 4

PostPosted: Mon Jul 05, 2010 1:07 pm    Post subject: Reply with quote

Thanks for the reply. I'll wait for an update.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group