Sometimes we get bored and change stuff in Toad just to mess with people.
I’m pretty sure there are people out there that really believe that. In our defense, I will say that we do change things pretty frequently, but it’s always in the pursuit of improving the user experience. However, sometimes there are unintended consequences and collateral damage.
So, when we do change something, we end up pleasing about 40% of the users, upsetting about 30% of the users, and the other 30% don’t even notice. By the way, I completely made up those numbers, but I would argue my made up numbers are more accurate than yours.
One of the more core components of the product is the Data Grid. This is the mechanism used to deliver and display the data from your queries and the contents of your Tables, Views, and Materialized Views. If we change something here, EVERYONE will notice.
Here is how the data grid in Toad looked several years ago
When Toadies upgrade their Toad to v10 or higher, one of the first things they notice is that a few of their buttons have disappeared or moved!
Where is my SaveAs Button?
In v10.0 the SaveAs button was completely removed from the data grid toolbar. The thinking was, let’s address the user users’ complaints about the UI being too cluttered. You could still export your data to Excel, but you needed to mouse-right-click on the data grid to get to the feature.
After a few thousand people complained, we got the idea to put it back. So in v10.5 and higher you’ll see it here.
Also, @boneist reminded me if you are looking for this feature on the right-click-mouse popup menu, it’s been relabeled to ‘Export Dataset.’ We thought that was more technically accurate and descriptive than ‘SaveAs.’ So the new people might find it easier, and the experienced Toadies will need to retrain their brain a few cells or so.
Where is my Single Record View Button?
Wait, what is the Single Record View Button? This view allows you work with your records one record at a time – kind of like an index card view versus a spreadsheet view. There was a button in older Toads that you could click to go straight to this view. It was in the top left hand corner of each data grid.
In Toad 10 and higher, this button was replaced by a control that allows you to select the columns you want to display in your grid. The single record view button was moved to the BOTTOM of the data grid.
If you are looking down at the bottom of your data grid and you don’t see the toolbar with the Single Record View button displayed, you may need to activate the Grid Navigator. Right-mouse-click in the data grid, select ‘Appearance’, then click on ‘Toggle Navigator.’
Take the Good with the Bad
While you are nursing your wounds, you can at least take advantage of all the new features that came with the data grid upgrade. Key features would be the visual settings (ability to set visual style with alternating color backgrounds) and the ability to group by values.
When we make the product better, we hope to take 2 steps forward. Sometimes we also take a step back. But, the users keep us in check and push us to get back that lost ground. If you are ‘missing’ something after you upgrade, be sure to read the release notes. If that doesn’t help, don’t forget to contact Quest Support. Or you can just come to me on Twitter