DB query to use the database views
-
On the DB query action dialog box of a form, click
Configure.
For a Data access activity, click Configure in the properties panel of the activity.
The <ActionName> dialog box is displayed. -
To specify the database connection string that holds the details of the relational database, on the
Database connection list, select the global variable or click
to manually enter the connection string.
For a DAS activity, select the process or server variable or click to manually enter the connection string.
-
On the database
Type list, select
Views. (Default: Tables)
All existing views appear on the Views list.
- On the Views list, select the view for which to retrieve records.
- Configure the query in the same way as for viewing a table. See DB query to get records in a table.
-
Click
OK.
The DB query action dialog box displays the Query.
- Click Save.