Defining the DEPTMAXSAL_DS SQL Data Source

Options > Data Access Getting Started > Additional Features > Creating the Department Maximum Salary Window > Defining the DEPTMAXSAL_DS SQL Data Source

Begin to define the DEPTMAXSAL_DS SQL data source by doing the following:

1. Choose New > Gadgets from the File menu in the Main window.

A new Gadgets buffer is opened ready for editing.

Note: If your empmgr.ilv buffer is still open, minimize it in the Main Window.

2. In Selection mode

, drag an SQL Data Source gadget from the Data Access palette to the Main window.

3. Double-click the SQL Data Source gadget.

The SQL Data Source inspector appears.

4. In the SQL Data Source inspector, type DEPTMAXSAL_DS in the top-left text field.

5. In the SQL Data Source inspector, choose Add Table... from the Query menu to add the I_EMP and I_DEPT tables to the DEPTMAXSAL_DS data source. This operation is described in the section Defining the EMP_DS SQL Data Source.

6. Do a join operation by dragging a line between the DEPTNO columns of the I_EMP and I_DEPT tables as you did in the section Joining Two Tables.

7. Add the following columns to the DEPTMAXSAL_DS data source table by dragging lines to the SELECT section from the:

NAME column in the I_DEPT table

SALARY column in the I_EMP table

The DEPTMAXSAL_DS SQL Data Source inspector panel now looks like this:

Note: The header of the NAME column taken from the I_DEPT table changes from NAME to I_DEPT.NAME to distinguish it from the NAME column in the I_EMP table.

Published date: 05/24/2022

Last modified date: 02/24/2022