The SQLDataGrid graphic

The SQLDataGrid is a graphic that enables you to interact with data stored in SQL databases. You can use the SQLDataGrid graphic in an InTouch application that you create in a published or managed mode.

The following picture shows the main components associated with the SQLDataGrid.

You can perform the following activities with the SQLDataGrid graphic:

• Insert or modify data in selected database tables and views.

• Delete rows from a database table (select the row and press the Delete key).

• Select data from existing tables and views.

• Run a custom SQL query.

This section provides the following information:

• The minimum configuration required by the SQLDataGrid graphic to retrieve data from a SQL database.

• The set of custom properties that must be configured to authenticate users and connect to the database.

• A list of the custom properties that define the parameters associated with a specific database and query to be retrieved.