codekingpro/portable-devtools
114k
1���� �sphinx.addnodes��document���)��}�(� rawsource�� ��children�]�(�docutils.nodes��target���)��}�(h�.. _query_tool_toolbar:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��query-tool-toolbar�u�tagname�h3�line�K�parent�h� _document�h�source��mD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\query_tool_toolbar.rst�ubh �section���)��}�(hhh]�(h �title���)��}�(h�`Query Tool Toolbar`:index:�h]�(h �index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Query Tool Toolbar��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh �Text����Query Tool Toolbar�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh � paragraph���)��}�(h��The *Query Tool* toolbar uses context-sensitive icons that provide shortcuts to5frequently performed tasks. If an icon is highlighted, the option is enabled;6if the icon is grayed-out, the task is disabled.�h]�(hJ�The �����}�(h hWh!hh"NhNubh �emphasis���)��}�(h�*Query Tool*�h]�hJ�7Query Tool�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�� toolbar uses context-sensitive icons that provide shortcuts to8frequently performed tasks. If an icon is highlighted, the option is enabled;9if the icon is grayed-out, the task is disabled.�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh �note���)��}�(h��The :ref:`Query Tool <query_tool>` and10:ref:`View/Edit Data <editgrid>` tools are actually different operating11modes of the same tool. Some controls will be disabled in either mode.�h]�hV)��}�(h��The :ref:`Query Tool <query_tool>` and12:ref:`View/Edit Data <editgrid>` tools are actually different operating13modes of the same tool. Some controls will be disabled in either mode.�h]�(hJ�The �����}�(h hh!hh"NhNubh �pending_xref���)��}�(h�:ref:`Query Tool <query_tool>`�h]�h �inline���)��}�(hh�h]�hJ�14Query Tool�����}�(h h�h!hh"NhNubah}�(h]�h]�(�xref��std��std-ref�eh]�h]�h]�uhh�h h�ubah}�(h]�h]�h]�h]�h]��refdoc��query_tool_toolbar�� refdomain�h��reftype��ref��refexplicit���refwarn��� reftarget��15query_tool�uhh�h"h#hKh hubhJ� and16�����}�(h hh!hh"NhNubh�)��}�(h� :ref:`View/Edit Data <editgrid>`�h]�h�)��}�(hh�h]�hJ�View/Edit Data�����}�(h h�h!hh"NhNubah}�(h]�h]�(h��std��std-ref�eh]�h]�h]�uhh�h h�ubah}�(h]�h]�h]�h]�h]��refdoc�h�� refdomain�h��reftype��ref��refexplicit���refwarn��h��editgrid�uhh�h"h#hKh hubhJ�n tools are actually different operating17modes of the same tool. Some controls will be disabled in either mode.�����}�(h hh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h{ubah}�(h]�h]�h]�h]�h]�uhhyh"h#hKh h&h!hubh �image���)��}�(h�T.. image:: images/query_toolbar.png18 :alt: Query tool toolbar19 :align: center20�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool toolbar��align��center��uri��images/query_toolbar.png��21candidates�}��*�h�suhh�h"h#hKh h&h!hubhV)��}�(h�[Hover over an icon in pgAdmin to display a tooltip that describes the icon's22functionality.�h]�hJ�]Hover over an icon in pgAdmin to display a tooltip that describes the icon’s23functionality.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh%)��}�(hhh]�(h*)��}�(h�File Options�h]�hJ�File Options�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j h!hh"h#hKubh �table���)��}�(hhh]�h �tgroup���)��}�(hhh]�(h �colspec���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j ubh �thead���)��}�(hhh]�h �row���)��}�(hhh]�(h �entry���)��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h jO h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jL ubah}�(h]�h]�h]�h]�h]�uhjJ h jG ubjK )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h jf h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jc ubah}�(h]�h]�h]�h]�h]�uhjJ h jG ubjK )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j} h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jz ubah}�(h]�h]�h]�h]�h]�uhjJ h jG ubeh}�(h]�h]�h]�h]�h]�uhjE h jB ubah}�(h]�h]�h]�h]�h]�uhj@ h j ubh �tbody���)��}�(hhh]�(jF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�*Open File*�h]�h`)��}�(hj� h]�hJ� Open File�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�QClick the *Open File* icon to display a previously saved query in the SQL Editor.�h]�(hJ�24Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Open File*�h]�hJ� Open File�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�< icon to display a previously saved query in the SQL Editor.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�
Accesskey + O�h]�hJ�
Accesskey + O�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j� ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�*Save File*�h]�h`)��}�(hj h]�hJ� Save File�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubjK )��}�(hhh]�(hV)��}�(h�hClick the *Save* icon to perform a quick-save of a previously saved query, or to access the25*Save* menu:�h]�(hJ�26Click the �����}�(h j1 h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h j9 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j1 ubhJ�L icon to perform a quick-save of a previously saved query, or to access the27�����}�(h j1 h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h jK h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j1 ubhJ� menu:�����}�(h j1 h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j. ubh �block_quote���)��}�(h��* Select *Save* to save the selected content of the SQL Editor panel in a file.28 29* Select *Save As* to open a new browser dialog and specify a new location to which to save the30 selected content of the SQL Editor panel.�h]�h �bullet_list���)��}�(hhh]�(h � list_item���)��}�(h�OSelect *Save* to save the selected content of the SQL Editor panel in a file.31�h]�hV)��}�(h�NSelect *Save* to save the selected content of the SQL Editor panel in a file.�h]�(hJ�Select �����}�(h jt h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h j| h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jt ubhJ�A to save the selected content of the SQL Editor panel in a file.�����}�(h jt h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK%h jp ubah}�(h]�h]�h]�h]�h]�uhjn h"h#hK%h jk ubjo )��}�(h��Select *Save As* to open a new browser dialog and specify a new location to which to save the32selected content of the SQL Editor panel.�h]�hV)��}�(h��Select *Save As* to open a new browser dialog and specify a new location to which to save the33selected content of the SQL Editor panel.�h]�(hJ�Select �����}�(h j� h!hh"NhNubh`)��}�(h� *Save As*�h]�hJ�Save As�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�w to open a new browser dialog and specify a new location to which to save the34selected content of the SQL Editor panel.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h j� ubah}�(h]�h]�h]�h]�h]�uhjn h"h#hK'h jk ubeh}�(h]�h]�h]�h]�h]��bullet�h�uhji h"h#hK%h je ubah}�(h]�h]�h]�h]�h]�uhjc h"h#hK%h j. ubeh}�(h]�h]�h]�h]�h]�uhjJ h j ubjK )��}�(hhh]�hV)��}�(h�
Accesskey + S�h]�hJ�
Accesskey + S�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubeh}�(h]�h]�h]�h]�h]�uhjE h j� ubeh}�(h]�h]�h]�h]�h]�uhj� h j ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj h j ubah}�(h]�h]�(� longtable��colwidths-given�eh]�h]�h]�uhj h j h!hh"h#hNubeh}�(h]��file-options�ah]�h]��file options�ah]�h]�uhh$h h&h!hh"h#hKubh%)��}�(hhh]�(h*)��}�(h�Filter/Limit Options�h]�hJ�Filter/Limit Options�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j h!hh"h#hK,ubj )��}�(hhh]�j )��}�(hhh]�(j! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j% ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j% ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j% ubjA )��}�(hhh]�jF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h jO h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h jL ubah}�(h]�h]�h]�h]�h]�uhjJ h jI ubjK )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h jf h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h jc ubah}�(h]�h]�h]�h]�h]�uhjJ h jI ubjK )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j} h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h jz ubah}�(h]�h]�h]�h]�h]�uhjJ h jI ubeh}�(h]�h]�h]�h]�h]�uhjE h jF ubah}�(h]�h]�h]�h]�h]�uhj@ h j% ubj� )��}�(hhh]�(jF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�*Filter*�h]�h`)��}�(hj� h]�hJ�Filter�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�(hV)��}�(h��Click the *Filter* icon to set filtering and sorting criteria for the data when in *View/Edit data35mode*. Click the down arrow to access other filtering and sorting options:�h]�(hJ�36Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Filter*�h]�hJ�Filter�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�A icon to set filtering and sorting criteria for the data when in �����}�(h j� h!hh"NhNubh`)��}�(h�*View/Edit data37mode*�h]�hJ�View/Edit data38mode�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�E. Click the down arrow to access other filtering and sorting options:�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j� ubjd )��}�(hX� * In the *SQL Filter*, you can enter a SQL query as filtering criteria.39 In *Data Sorting*, you can select the column and specify the order for sorting.40 41* Click *Filter by Selection* to show only the rows containing the values in the selected cells.42 43* Click *Exclude by Selection* to show only the rows that do not contain the values in the44 selected cells.45 46* Click *Remove Sort/Filter* to remove any previously selected sort or filtering options.�h]�jj )��}�(hhh]�(jo )��}�(h��In the *SQL Filter*, you can enter a SQL query as filtering criteria.47In *Data Sorting*, you can select the column and specify the order for sorting.48�h]�hV)��}�(h��In the *SQL Filter*, you can enter a SQL query as filtering criteria.49In *Data Sorting*, you can select the column and specify the order for sorting.�h]�(hJ�In the �����}�(h j h!hh"NhNubh`)��}�(h�*SQL Filter*�h]�hJ�50SQL Filter�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�6, you can enter a SQL query as filtering criteria.51In �����}�(h j h!hh"NhNubh`)��}�(h�*Data Sorting*�h]�hJ�Data Sorting�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�>, you can select the column and specify the order for sorting.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK8h j� ubah}�(h]�h]�h]�h]�h]�uhjn h"h#hK8h j� ubjo )��}�(h�_Click *Filter by Selection* to show only the rows containing the values in the selected cells.52�h]�hV)��}�(h�^Click *Filter by Selection* to show only the rows containing the values in the selected cells.�h]�(hJ�Click �����}�(h j? h!hh"NhNubh`)��}�(h�*Filter by Selection*�h]�hJ�Filter by Selection�����}�(h jG h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j? ubhJ�C to show only the rows containing the values in the selected cells.�����}�(h j? h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK;h j; ubah}�(h]�h]�h]�h]�h]�uhjn h"h#hK;h j� ubjo )��}�(h�iClick *Exclude by Selection* to show only the rows that do not contain the values in the53selected cells.54�h]�hV)��}�(h�hClick *Exclude by Selection* to show only the rows that do not contain the values in the55selected cells.�h]�(hJ�Click �����}�(h ji h!hh"NhNubh`)��}�(h�*Exclude by Selection*�h]�hJ�Exclude by Selection�����}�(h jq h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h ji ubhJ�L to show only the rows that do not contain the values in the56selected cells.�����}�(h ji h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK=h je ubah}�(h]�h]�h]�h]�h]�uhjn h"h#hK=h j� ubjo )��}�(h�WClick *Remove Sort/Filter* to remove any previously selected sort or filtering options.�h]�hV)��}�(hj� h]�(hJ�Click �����}�(h j� h!hh"NhNubh`)��}�(h�*Remove Sort/Filter*�h]�hJ�Remove Sort/Filter�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�= to remove any previously selected sort or filtering options.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK@h j� ubah}�(h]�h]�h]�h]�h]�uhjn h"h#hK@h j� ubeh}�(h]�h]�h]�h]�h]�j� h�uhji h"h#hK8h j� ubah}�(h]�h]�h]�h]�h]�uhjc h"h#hK8h j� ubeh}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�
Accesskey + F�h]�hJ�
Accesskey + F�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j� ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�Limit Selector�h]�hJ�Limit Selector�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKBh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�\Select a value in the *Limit Selector* to limit the size of the dataset to a number of rows.�h]�(hJ�Select a value in the �����}�(h j h!hh"NhNubh`)��}�(h�*Limit Selector*�h]�hJ�Limit Selector�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�6 to limit the size of the dataset to a number of rows.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKBh j ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�
Accesskey + R�h]�hJ�
Accesskey + R�����}�(h j- h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKBh j* ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j� ubeh}�(h]�h]�h]�h]�h]�uhj� h j% ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj h j" ubah}�(h]�h]�(� longtable�j eh]�h]�h]�uhj h j h!hh"h#hNubeh}�(h]��filter-limit-options�ah]�h]��filter/limit options�ah]�h]�uhh$h h&h!hh"h#hK,ubh%)��}�(hhh]�(h*)��}�(h�Query Editing Options�h]�hJ�Query Editing Options�����}�(h jf h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jc h!hh"h#hKFubh�)��}�(h�\.. image:: images/query_editing.png57 :alt: Query tool editing options58 :align: center59�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool editing options��align��center��uri��images/query_editing.png�h�}�h�j� suhh�h"h#hKHh jc h!hubj )��}�(hhh]�j )��}�(hhh]�(j! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j� ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j� ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j� ubjA )��}�(hhh]�jF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j� ubah}�(h]�h]�h]�h]�h]�uhj@ h j� ubj� )��}�(hhh]�(jF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�*Edit*�h]�h`)��}�(hj h]�hJ�Edit�����}�(h j
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKSh j ubah}�(h]�h]�h]�h]�h]��morerows�KuhjJ h j ubjK )��}�(hhh]�hV)��}�(h�YUse the *Edit* menu to search, replace, or navigate the code displayed in the SQL Editor:�h]�(hJ�Use the �����}�(h j* h!hh"NhNubh`)��}�(h�*Edit*�h]�hJ�Edit�����}�(h j2 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j* ubhJ�K menu to search, replace, or navigate the code displayed in the SQL Editor:�����}�(h j* h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKSh j' ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubjK )��}�(hhh]�h}�(h]�h]�h]�h]�h]�uhjJ h j ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�MSelect *Find* to provide a search target, and search the SQL Editor contents.�h]�(hJ�Select �����}�(h je h!hh"NhNubh`)��}�(h�*Find*�h]�hJ�Find�����}�(h jm h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h je ubhJ�@ to provide a search target, and search the SQL Editor contents.�����}�(h je h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKUh jb ubah}�(h]�h]�h]�h]�h]�uhjJ h j_ ubjK )��}�(hhh]�hV)��}�(h�Cmd+F�h]�hJ�Cmd+F�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKUh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j_ ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�]Select *Replace* to locate and replace (with prompting) individual occurrences of the target.�h]�(hJ�Select �����}�(h j� h!hh"NhNubh`)��}�(h� *Replace*�h]�hJ�Replace�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�M to locate and replace (with prompting) individual occurrences of the target.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�(Option+Cmd+F (MAC)60Ctrl+Shift+F (Others)�h]�hJ�(Option+Cmd+F (MAC)61Ctrl+Shift+F (Others)�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�MSelect *Go to Line/Column* to go to specified line number and column position�h]�(hJ�Select �����}�(h j� h!hh"NhNubh`)��}�(h�*Go to Line/Column*�h]�hJ�Go to Line/Column�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�3 to go to specified line number and column position�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKZh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�Cmd+L or Ctrl+L�h]�hJ�Cmd+L or Ctrl+L�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKZh j ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�@Select *Indent Selection* to indent the currently selected text.�h]�(hJ�Select �����}�(h j@ h!hh"NhNubh`)��}�(h�*Indent Selection*�h]�hJ�Indent Selection�����}�(h jH h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j@ ubhJ�' to indent the currently selected text.�����}�(h j@ h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK\h j= ubah}�(h]�h]�h]�h]�h]�uhjJ h j: ubjK )��}�(hhh]�hV)��}�(h�Tab�h]�hJ�Tab�����}�(h ji h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK\h jf ubah}�(h]�h]�h]�h]�h]�uhjJ h j: ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�SSelect *Unindent Selection* to remove indentation from the currently selected text.�h]�(hJ�Select �����}�(h j� h!hh"NhNubh`)��}�(h�*Unindent Selection*�h]�hJ�Unindent Selection�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�8 to remove indentation from the currently selected text.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK^h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h� Shift+Tab�h]�hJ� Shift+Tab�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK^h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�_Select *Toggle Comment* to comment/uncomment any lines that contain the selection in SQL style.�h]�(hJ�Select �����}�(h j� h!hh"NhNubh`)��}�(h�*Toggle Comment*�h]�hJ�Toggle Comment�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�H to comment/uncomment any lines that contain the selection in SQL style.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK`h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�hV)��}�(h�Cmd+/�h]�hJ�Cmd+/�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK`h j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�6Select *Clear Query* to clear the query editor window.�h]�(hJ�Select �����}�(h j h!hh"NhNubh`)��}�(h�
*Clear Query*�h]�hJ�Clear Query�����}�(h j# h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�" to clear the query editor window.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh j ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubjK )��}�(hhh]�hV)��}�(h�Cmd+.�h]�hJ�Cmd+.�����}�(h jD h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh jA ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�QSelect *Format SQL* to format the selected SQL or all the SQL if none is selected�h]�(hJ�Select �����}�(h jd h!hh"NhNubh`)��}�(h�*Format SQL*�h]�hJ�62Format SQL�����}�(h jl h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jd ubhJ�> to format the selected SQL or all the SQL if none is selected�����}�(h jd h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKdh ja ubah}�(h]�h]�h]�h]�h]�uhjJ h j^ ubjK )��}�(hhh]�hV)��}�(h�Shift+Cmd+K�h]�hJ�Shift+Cmd+K�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKdh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j^ ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubeh}�(h]�h]�h]�h]�h]�uhj� h j� ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj h j� ubah}�(h]�h]�(� longtable�j eh]�h]�h]�uhj h jc h!hh"h#hNubeh}�(h]��query-editing-options�ah]�h]��query editing options�ah]�h]�uhh$h h&h!hh"h#hKFubh%)��}�(hhh]�(h*)��}�(h�Query Execution�h]�hJ�Query Execution�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j� h!hh"h#hKhubh�)��}�(h�^.. image:: images/query_execution.png63 :alt: Query tool execute options64 :align: center65�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool execute options��align��center��uri��images/query_execution.png�h�}�h�j� suhh�h"h#hKjh j� h!hubj )��}�(hhh]�j )��}�(hhh]�(j! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j� ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j� ubj! )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j� ubjA )��}�(hhh]�jF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKsh j ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubjK )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j) h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKsh j& ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubjK )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j@ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKsh j= ubah}�(h]�h]�h]�h]�h]�uhjJ h j ubeh}�(h]�h]�h]�h]�h]�uhjE h j ubah}�(h]�h]�h]�h]�h]�uhj@ h j� ubj� )��}�(hhh]�(jF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�*Stop*�h]�h`)��}�(hjk h]�hJ�Stop�����}�(h jm h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h ji ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKuh jf ubah}�(h]�h]�h]�h]�h]�uhjJ h jc ubjK )��}�(hhh]�hV)��}�(h�MClick the *Stop* icon to cancel the execution of the currently running query.�h]�(hJ�66Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Stop*�h]�hJ�Stop�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�= icon to cancel the execution of the currently running query.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKuh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h jc ubjK )��}�(hhh]�hV)��}�(h�
Accesskey + Q�h]�hJ�
Accesskey + Q�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKuh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h jc ubeh}�(h]�h]�h]�h]�h]�uhjE h j` ubjF )��}�(hhh]�(jK )��}�(hhh]�hV)��}�(h�*Execute script*�h]�h`)��}�(hj� h]�hJ�Execute script�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKwh j� ubah}�(h]�h]�h]�h]�h]�uhjJ h j� ubjK )��}�(hhh]�(hV)��}�(h��Click the *Execute script* icon to either execute or refresh the query highlighted in the SQL67editor panel. Click the down arrow to access other execution options:�h]�(hJ�68Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Execute script*�h]�hJ�Execute script�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� icon to either execute or refresh the query highlighted in the SQL69editor panel. Click the down arrow to access other execution options:�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKwh j� ubjd )��}�(hXl * Add a check next to *Auto rollback on error?* to instruct the server to automatically roll back70 a transaction if an error occurs during the transaction.71 72* Add a check next to *Auto commit?* to instruct the server to automatically commit each73 transaction. Any changes made by the transaction will be visible to others, and74 durable in the event of a crash.�h]�jj )��}�(hhh]�(jo )��}�(h��Add a check next to *Auto rollback on error?* to instruct the server to automatically roll back75a transaction if an error occurs during the transaction.76�h]�hV)��}�(h��Add a check next to *Auto rollback on error?* to instruct the server to automatically roll back77a transaction if an error occurs during the transaction.�h]�(hJ�Add a check next to �����}�(h j78