Red Gate forums :: View topic - Sortable columns in table detail popup window
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

Sortable columns in table detail popup window

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



Joined: 05 Nov 2013
Posts: 4

PostPosted: Mon Jul 07, 2014 1:15 pm    Post subject: Sortable columns in table detail popup window Reply with quote

When hovering over a table name in the query window a context window appears by clicking on the "[schema].[table], [comments]" tooltip. The information to script or get a summary is made possible; it would be very helpful to be able to sort by column name [additionally by data type too] in the pop up window... I have used other tools in the past with this capability; once one gets used to it it comes in mighty handy (it is tedious to look through 200 columns in ordinal order, or find the one xml column in the list).

Is this something that can easily be added to the product?

Thanks in advance,
John
Back to top
View user's profile Send private message
Aaron Law



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

PostPosted: Mon Jul 07, 2014 5:38 pm    Post subject: Reply with quote

Hi John,

I saw your request a while back on UserVoice and gave it a go but decided not to look into it too much as it was becoming complicated than I'd hoped. In theory it should be easy since the winforms DataGridView comes with the sorting functionality built in. However our popup can't take focus away from the main editor window and clicking to sort gave focus to the grid, which resulted in our popup closing.

I just gave it another go and I think I've found a simple work around, if all goes well I'll include it in a beta build this week. I'll let you know when the build is up.

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



Joined: 05 Nov 2013
Posts: 4

PostPosted: Mon Jul 07, 2014 5:52 pm    Post subject: Reply with quote

Aaron - Thanks so much for the quick response. Thanks for giving it another shot, and good luck!

Smile
John
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:16 am    Post subject: Reply with quote

Hi John,

The columns should now be sortable in 6.4.0.266, hope that helps!
Back to top
View user's profile Send private message
JohnHennesey



Joined: 05 Nov 2013
Posts: 4

PostPosted: Thu Jul 10, 2014 12:25 pm    Post subject: Thanks! Reply with quote

Love it! Thanks! And thank you for the quick turn around!!
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