Red Gate forums :: View topic - BUG: ALTER PROCEDURE doesn't include all of the text
Return to www.red-gate.com RSS Feed Available

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

BUG: ALTER PROCEDURE doesn't include all of the text

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Airn5475



Joined: 21 Sep 2010
Posts: 5
Location: Sterling, OH

PostPosted: Tue Jul 08, 2014 6:44 pm    Post subject: BUG: ALTER PROCEDURE doesn't include all of the text Reply with quote

If type in ALTER PROCEDURE and select a Stored Procedure in the list, the code preview pop up will come up and display the stored procedure text including any comments before "CREATE PROCEDURE".

If I hit TAB the Stored Procedure text will be inserted into the document, however, it does not include comments before ALTER PROCEDURE.

Can this please be corrected? We often times have our Author, Date Created and Change History text in comments before the stored proc.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 249
Location: Red Gate Software

PostPosted: Wed Jul 09, 2014 10:03 am    Post subject: Reply with quote

Hi Airn5475,

It looks like this might have been originally designed to work like that in Prompt, possibly because it was considered odd to insert text before the current line and potentially scroll forwards or just to make it consistent with the rest of the code that Prompt inserts (they all overwrite the current word and append the extra text)

I can see how this would be annoying if you're relying on the comments before the stored procedure to be preserved. I'll have a look into this today and see if it's a simple change to make. Otherwise, we currently have a feature request on UserVoice here, so please do add your vote as we use the votes to help prioritise what to work on next.

A possible work around would be to use the Script as Alter feature (F12) which will keep the comments.

Thanks,
Aaron.
Back to top
View user's profile Send private message
Airn5475



Joined: 21 Sep 2010
Posts: 5
Location: Sterling, OH

PostPosted: Wed Jul 09, 2014 1:06 pm    Post subject: Reply with quote

Hi Aaron,
Thanks for the quick response. I knew I should have looked in UserVoice first. You guys do a great job of maintaining that list and pulling items off of it! I figured this was more of a bug and not a feature, so I didn't look there first. I have upvoted the item accordingly.

I do agree that it may seem weird to have the comments appear before the text I'm working on. What's worse is when those comments are lost!

Thanks for the reminder about F12, I some how had forgotten about that!

Thanks for checking into this.

-Aaron
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 249
Location: Red Gate Software

PostPosted: Thu Jul 10, 2014 11:05 am    Post subject: Reply with quote

Hi Aaron,

Things are looking good - we've got a version of this working without having to drastically change the insertion system and it doesn't feel odd that the comments are inserted before the cursor. We'll do some more testing on it over the next few days and hopefully should be able to include it in a beta build next week. I'll let you know if there's any more developments.

Thanks,
Aaron.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 249
Location: Red Gate Software

PostPosted: Fri Jul 18, 2014 2:09 pm    Post subject: Reply with quote

This should now be in the latest beta build (6.4.0.300) let me know if you come across any problems with it!
Back to top
View user's profile Send private message
Airn5475



Joined: 21 Sep 2010
Posts: 5
Location: Sterling, OH

PostPosted: Fri Jul 18, 2014 4:13 pm    Post subject: Reply with quote

Hey Aaron,
I downloaded the beta and the functionality works as expected.

Thanks for getting this in there!

-Aaron
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