refresh data
It would be great if we could have a quick shortcut icon or key next to "Refresh Data" (Query Tab), when after we run a query, we could retrieve the data again (without having to go to table and click - Retrieve Data). Small quirk, but massively productive.
Dane Balia
shared this idea
You can define your own shortcut for this command as follows:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Keyboard’ branch.
3. Type ‘TableRetrieveData’ in the ‘Show Commands Containing’ field.
4. Find and select the ‘Database.TableRetrieveData’ item in the list below.
5. Set the focus in the ‘Press shortcut keys’ field.
6. Press the key combination you want to assign to the command. This combination will appear in the ‘Press shortcut keys’ field.
7. Click the ‘Assign’ button next to this field.
8. Click ‘OK’.
-
Dane Balia
commented
Hi
I'm sorry - I think you missed the point of what I was saying (maybe I was not clear enough).
When I execute a SQL query that filters the data, "Refresh" only refreshes my existing query.
That's perfect, but it would be nice for a shortcut key/icon that would then "retrieve" the table's data (to see what was affected by the previously run SQL.Using TableRetrieveData only refreshes the existing SQL query - as the "Refresh" icon in Query editor. Even if I remove the SQL query from the Query Editor, it still displays the data of my query. That doesn't seem right or logical. Your thoughts?
Great tool, just trying to help make it better.
Thanks (apologies if I missed something obvious from your response)