Tip: If Favorite Replaces Editor Content is checked and you want to insert the chosen query favorite into the Custom Query Editor at the current cursor position instead you can hold any of these keys ⇧ ⌥ ⌘ while choosing the desired favorite via mouse to toggle Favorite Replaces Editor Content setting temporarily (or visa versa). The query favorite SELECT FROM WHERE will be inserted into the Custom Query Editor - according to the setting of Favorite Replaces Editor Content (settable in Custom Query Editor's gear menu). type in the query field: SELECT FROM WHEREĪfter creating it you can click at the Query Favorites button and choose Select.open the Query Favorites Editor by choosing Edit Favorites….holding ⌥ key and click at the Query Favorites button, choose Save Selection to Favorites.
type SELECT FROM WHERE in the Custom Query Editor.To create this query favorite you have two options: export selected query favorites in a SPF fileĪ frequently used SQL statement is SELECT FROM WHERE .change the storage location (global or document) by dragging it.rearrange the order of appearance in the popup menu by dragging it.
Furthermore each query favorite can be inserted by using an user-defined tab trigger - an alphanumeric string which can be typed in the Custom Query Editor and it will be replaced by the corresponding query favorite after pressing the tab ⇥ key. A query favorite can be static but also dynamic which means it will be evaluated on run-time. which can be saved globally - accessible from each connection window - or document-based ( SPF file) if the query favorite is connection specific. Query Favorites are useful for frequently used SQL statements, text chunks, etc.
0 kommentar(er)
