Posted by Kyle Hankinson September 23, 2020
SQLPro supports multiple cursors. This allows a users to perform certain actions with fewer keystrokes.
There are two different ways available to select multiple cursors. The first, is by holding
Option while dragging the mouse cursor up or down between lines.
The second method is by using the keyboard shortcut
Option along with
Once multiple cursors have been selected, the following keyboard shortcuts are available.
←/→to move text selection to the left and right one character.
←/→to move text selection left/right one word.
←/→to move and highlight text selection to the left and right.
←/→to move and highlight text selection left/right one word.
Deleteto delete from the curors beginnings to the end of the next word.
Deleteto delete from the curors beginnings to the end of the line.
Any feedback or issues with multi-cursor support should be added to the origional request ticket.
Posted by Kyle Hankinson August 12, 2020
Server based results sorting is a helpful and quick way for users to sort all results from a table without needing to write SQL. As of SQLPro v2020.71 is has been enabled by default. Using it is easy as can be. Simply click the header of a result set. The updated sort statement appear 'ghosted' in your query.
Server based sorting can be disabled via the 'SQLPro' -> 'Preferences' menu item. Once the preferences dialog is visible uncheck the 'Server based results sorting'.
Server based sorting only works for simple queries. If the query is complex, then the results will be sorted locally using the 'in memory results'.
Posted by Kyle Hankinson June 30th, 2020
The autocomplete delay option is a perference which allows users to determine the time it takes for the autocomplete window to be displayed when typing in the query editor. It can be found on the
General page of SQLPro
The default autocomplete delay is 1.25 seconds. With the delay, autocomplete would appear as follows.
Setting the autocomplete delay to 0 would display autocomplete after most-every keystroke.
When entering a database, schema or table, followed by a period, such as:
SELECT * FROM myDatabase.
Autocomplete will instantly appear showing all children of the parent object.
Autocomplete will also not appear automatically after the following characters:
It has generally been found that users tend to want whitespace (such as a newline, space, tab, etc) after those characters. Autocomplete can still be triggered by hitting escape.