› User interface › Forms › Form events and actions › Form actions › DB query action › DB query to use the database views

DB query to use the database views

Create a database query to use the database views.

Before you begin
To create a DB query action, you must to set up a database connection string. The following sample data values can be provided:

  • All numeric types = -1

  • Dates = 01/01/1900

  • Byte = 0

  • String = Blank String

  • Boolean = False

  1. On the DB query action dialog box of a form, select Configure.
    The DBQuery dialog box is displayed.
  2. To specify the database connection string that holds the details of the relational database, select either Database connection.

    • Local (Default): Select a global variable or select to manually enter the connection string.

    • External: To use the database connection from external storage, enter the secret name for the connection secret stored in the configured external storage.

    A list of schema that the database user has permission to access is displayed.

  3. On the Schema list, select a database schema to use for retrieving database objects.

    The schema list displays all schemas that the database user has permission to access. If no schema is explicitly selected, the system uses the default schema for the database user (typically dbo for SQL Server).

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

    All existing views appear on the Views list.

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

    The DB query action dialog box displays the Query.

  8. Select Save.