Welcome > User interface > Forms > Form events and actions > Form actions > DB query action > Create a DB query > DB query to use the database views

DB query to use the database views

  1. 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.
  2. 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.

  3. On the database Type list, select Views. (Default: Tables)

    All existing views appear on the Views list.

  4. On the Views list, select the view for which to retrieve records.
  5. Configure the query in the same way as for viewing a table. See DB query to get records in a table.
  6. Click OK.

    The DB query action dialog box displays the Query.

  7. Click Save.