Dialog Boxes
Various elements in the SQL Data Source inspector panel can call different dialog boxes:
SQL Data Source Properties Dialog Box
The SQL Data Source Properties dialog box is used for defining various properties of the data source. It is called by the Properties... menu item (see page 174) in the File menu of the SQL Data Source inspector panel.
Label | Description |
|---|---|
Read only | Menu: Yes, No. Default: No. Explanation: Yes = The data source cannot be edited. No = The data source can be edited. |
Distinct | Menu: Yes, No. Default: No. Explanation: Yes = Duplicate rows are merged. No = Duplicate rows are left intact. |
Updatable tables | Menu: List of tables in FROM section. Default: First table that has been added to the data source. Explanation: The table that the data source updates. A data source can only update one table. |
Concurr. control (concurrency control) | Menu: On, Off. Default: Off. Explanation: On = The data source takes extra steps to ensure that a row has not been updated by another user from the time the row was retrieved from the database and when it was resubmitted to the database. Off = The data source does not take such extra steps. |
Fetch policy | Menu: As Needed, Immediate. Default: As Needed. Explanation: As Needed = Selected data is retrieved from the database and stored in data cache only as data is needed. For As Needed to be effective, Auto Commit (see below) must be No. When Auto Commit is Yes, Immediate is implied. Immediate = All selected data is retrieved at once and stored in data cache. |
Auto commit | Menu: Yes, No. Default: Yes. Explanation: Yes = After each operation, a COMMIT command is automatically sent to the database. No = COMMIT command is not sent to database, and must be done by other means (for example, programming). |
Auto refresh | Menu: Yes, No. Default: No. Explanation: Yes = Each time a row is inserted or updated, it is sent to the database and retrieved for verification in the data source. No = Row is not retrieved. |
Auto select | Menu: Yes, No. Default: No. Explanation: Yes = Data source recomputes its data by submitting a query to the database each time a foreign data source, to which the data source is connected by parameters, changes. No = Data source does not recompute its data. |
Insert nulls | Menu: Yes, No. Default: Yes. Explanation: Yes = Null columns are inserted in the database table when a row is inserted. Database schema default values are not taken into account since a null value is explicitly specified, but performance may be increased. No = Null columns are not inserted. |
Dynamic SQL | Menu: Yes, No. Default: Yes. Explanation: Yes = When a row is updated in the database, only those values of columns in remote tables whose values have changed in current table are set. No = All values of columns in remote tables are set. |
Use bound vars | Menu: Yes, No. Default: Yes. Explanation: Yes = When column values are sent to the database, are packaged in bound variables of the native database call interface, instead of being part of the SQL statements. When combined with Dynamic SQL = No and Insert Nulls = Yes, can greatly increase performance. No = Column values are not packaged in bound variables. |
Rows count limit | Menu: None. Default: No default. Explanation: Maximum number of rows that can be retrieved. If empty, unlimited number of rows can be retrieved. |
Connection | Menu: None. Click button to open the Connect dialog box. Default: No default. Explanation: Specifies the SQL session by which the data source will communicate with the database. |
Query conjunct | Menu: None. Default: No default. Explanation: Additional SQL selection criteria that will be added to criteria in Where and/or Having rows. |
Transaction manager | Menu: List of available transaction managers. Default: No default. Explanation: Name of the transaction manager used by this data source. |
Use property manager | Menu: Yes, No. Default: Yes. Explanation: Yes = The data source uses a property manager. No = The data source does not use a property manager. |
Connect Dialog Box
The Connect dialog box is used for connecting the data source to a database, that is, for establishing an SQL session. It is called by the following menu items in the SQL Data Source inspector panel when the data source is not connected to a database:
Properties... —> Connection button in the SQL Data Source Properties panel that appears. See Properties... menu item on page 174 and Connection field on page 188.The Connect dialog box that appears depends on the type of DBMS being used. Below is a Connect dialog box for an odbc DBMS.
Element | Description |
|---|---|
Name field | The name of the SQL session or (Custom). If (Custom), must fill in other fields to create a new SQL session. |
User field | The system database user name. |
Password field | The user password. |
Database field | The name of the database. |
Options field | The data necessary to connect to the database. |
Keep Password checkbox | When not checked, forces the user to enter a password each time a connection to the database is requested. |
OK button | Validates the entries and creates an SQL session having the name entered in the Name field. |
Cancel button | Closes the Connect dialog box without validating the entries. No SQL session is created. |
Source Dialog Box
The Source dialog box is used for reading the SQL statements automatically created by the user’s screen operations. The Source dialog box is called by the View Source... menu item (see page 174) of the File menu in the SQL Data Source inspector panel if the data source is connected to a database. If not already connected to a database, this menu item calls the Connect dialog box (see page 188). After connecting to the database through the Connect dialog box, the Source dialog box then appears.
The Source dialog box shows the SQL statements corresponding to the current data source. It is read-only.
Button | Description |
|---|---|
Close | Closes the Source dialog box. |
Select Tables Dialog Box
The Select Tables dialog box is used for selecting tables to be added to the data source from the currently connected database. A representation of the table is placed in the FROM section of the SQL Data Source inspector panel. See the picture of the IliSQLDataSource Inspector Panel.
The Select Tables dialog box is called by the Add Tables... menu item of the Query menu in the SQL Data Source inspector panel (if the data source is connected to a database). If not already connected to a database, this menu item calls the Connect dialog box. After connecting to the database through the Connect dialog box, the Select Tables dialog box then appears.
The Select Tables dialog box consists of:
A list on the left side of the box containing all the tables owned by the selected user.A list on the right side of the box, initially empty, to which the end user can add tables.Two buttons for moving selected database tables:-> Adds the table selected in the left list to the right list.<- Removes the selected table from the right list. 
Note: To display the columns of a table in the left list, double-click on its name or on the '+' to the left of its name. |
Button | Description |
|---|---|
OK | Adds the selected database tables to the data source. |
Cancel | Closes the Select Table dialog box without adding any table to the data source. |
Question Dialog Box
The Question dialog box is used for confirming a command by the user. It is called by the following menu items of the Query menu in the SQL Data Source inspector panel when an item corresponding to the command is selected in the panel:
The Question dialog box allows you to confirm one of the above three commands.
Button | Description |
|---|---|
OK | Deletes the selected item. |
Cancel | Closes the Question dialog box and no item is deleted. |
Differences Dialog Box
This dialog box is used to show the differences between the data source tables and the database tables—in the event that a table has been modified in the database by another user. When you synchronize a data source with a table (or all tables) the structural information in the FROM data source table changes. (These operations are on the Query menu. If there are differences between the tables, the above window is displayed.) To update the table(s) in the FROM section press Validate. To update the table(s) in the SELECT section as well, check the Update data source columns box and Validate.
Column | Description |
|---|---|
State | Indicates whether something has been added to, removed from, or changed in the database. |
Table | Shows the table name being synchronized. |
Column | Shows the column being synchronized. |
Attributes | The four possible types are: Max length, PartofKey, Datatype, Nullable. |
Published date: 05/24/2022
Last modified date: 02/24/2022
