Data Source Tree Pane

On initial entry to the Data Source, the Tree Pane shows the database structure of Tables and Views. A finder (Search) facility is available to narrow the full tree structure.

Enter any characters (Either File or part file number e.g. F42 or Address) in the Look for: field and then select the Find icon button

or hit ENTER and the result of the search will be available in Tables or Views depending whether the search criteria is met.

The Data Source Tree shows any valid databases as a result of your sign on with a

alongside. In this example UTB_ONEWORLD database is displayed.

Select the

and then the two options Tables and Views are displayed in the tree structure. These may be toggled on / off with the

icons.

These two then may or may not be displayed with a

depending on what has been stored in the database.

In this example F42 has been entered in the 'Look for' field and a search carried out in the database 'Tables' only. The 'Look In' drop down box gives three options All (both Tables and Views), Tables only or Views only. Table details are available to view and select by toggling the

button.

The Tables tree option shows a full list of all tables available in the database. This list can be reduced selectively by use of the Filter as described above.

(In the example the Filter or Look In facility has been used to select all Tables starting F42).

An alternative method of table selection, is to click the curser in the table list and then type either the full table designation (F4101) or the first part of the table (F41) and the curser will then 'go to' that position in the table. You can then either drag and drop the full table or move the curser to the required table and drag the new resulting table...

Each Table

listed has two further selection options in the tree of Columns

or Indexes

. Select any Table (F4201_Sales_Order_Header_File in this example)

button to toggled the Columns / Indexes on / off.

Another feature of the Data Source Tree pane is the ability to Right Click on a Table to display a window with two options:

If you select this option on the table it will then open the table with all columns in the Query Builder pane, as if the table had been dragged into the Builder Pane and all fields selected. But note, when you then select the Designer option the table is not left in the Query Builder Pane.

If you select this option on the table it will then add the table to the Query Builder Pane as if it had been dragged and dropped. It will remain in the query Builder Pane.

Expand the Table Columns by selecting the

to toggle all column names on / off in the tree. The columns are displayed for information and show by icon whether it is a keyed field or not. These Columns will also be shown when a Table is dragged from the Data Source Tree Pane to the Query Builder Pane as described later.

Right click on any field in the expanded Columns tree to show the Database Object Properties screen

In the example shown for the SDDOCO_Order_number field; it is 10 numeric characters with no decimal (0 Scale) and 4 bytes long. This object properties information is not available in the Query Builder Pane.

Expand the Table Indexes by selecting the

toggle and any indexes that exist in the database will be displayed. If they exist they can be used to speed up the execution of the query.

In the example shown, the F4201_Sales_Order_Header_File Indexes have been expanded and show nine (9) defined indexes. Further expansion shows the key fields in the Index.

In the example View F42019A_F42019_Sales_Order_Header_all_Columns has been displayed.

If a view is available it will have been set up previously in the database and is a very useful way of creating a query with a reduced column set.

Expand the View Columns by selecting the

toggle and all columns will be listed in the tree. The columns are displayed for information and show by icon whether it is a keyed field or not. These Columns will also be shown when a View is dragged from the Data Source Tree Pane to the Query Builder Pane as described later.

In database design, a primary key is a value that can be used to identify a unique row in a table. Attributes are associated with it. Examples are names in a telephone book (to look up telephone numbers) and words in a dictionary (to look up definitions).

An index is a feature in a database that allows quick access to the rows in a table. The index is created using one or more columns of the table. Not only is the index smaller than the original table (due to having fewer columns), but it is optimized for quick searching, usually via a balanced tree

Both the above features exist in a database column if it is both keyed and indexed.

A foreign key is a field or group of fields in a database record that point to a key field or group of fields forming a key of another database record in some (usually different) table. Usually a foreign key in one table refers to the primary key of another table

		Filter and Find (search) the tree items

		Database Schema

		Tables list
		Views list

		Table
		Expand table columns
		Expand table indexes

		Column
		Keyed column
		Indexed column