Example: Using a Selection Box in a Table

In tables we can use the mouse to select records by drawing a selection box.  Ctrl-click and drag anywhere in the table to select all records with any part in the selection box.   Using the Alt key makes that a deselect: Alt-Ctrl click and drag anywhere in the table to deselect records with any part of the record in the deselection box.

 

i_tblsbox01_01.png

 

We import the ubiquitous Nwind database often used as an example for database applications in Microsoft Windows and we click open the Customers table.

 

i_tblsbox01_02.png

 

Using the mouse we Ctrl-click and drag to draw a selection box that touches some of the records.

 

i_tblsbox01_03.png

 

All records which had any part within the selection box are now selected.

 

i_tblsbox01_04.png

 

Next, using Alt-Ctrl-click and drag we draw a deselection box that touches some of the selected records.

 

i_tblsbox01_05.png

 

Those records that were touched by the deselection box are now no longer part of the selection.

 

Note that in using either the selection or deselection boxes we do not have to fully enclose all of the records.  Simply drawing a box that touches any part of the record, that is, any part of any field in a record, is enough.

 

See Also

Selection

 

Select Dialog

 

Tables

 

Example: Mouse Selection in a Drawing Window - Using the mouse to select objects in a drawing window.   This could be a drawing layer in a map or simply in a drawing window.

 

Example: Combining Selections using the Select Dialog - How to use selections to solve a one-off problem casually that would be more difficult to solve rigorously with SQL.   The objective in the example's scenario is to visit a point of tourist interest while travelling.    We will use mouse selection as well as the Select dialog.

 

SQL Example: Using Selection Query Functions - How to manipulate selections within a query.

 

Example: Construct JSON String using Select and Transform - Use the Select and Transform dialogs to manually construct a JSON string using values from other fields in a table. Shows how we can manipulate text to build desired contents in a field.