Select Database Table Wizard - Select DBTable Element Page

Applies to TestComplete 15.62, last modified on March 19, 2024

The Select Database Table wizard is used to modify DBTable elements of the Stores > DBTables collection. The Specify DBTable Element page is the first page of the wizard:

Element page

Click the image to enlarge it.

On this page, you can specify the following information:

  • In the Name edit box you can specify the name of the DBTable element to be created upon closing the wizard. If you invoked the wizard from the DBTable Element editor, the Name edit box is read-only (to rename the element, use the context menu of the Project Explorer panel).

    Note: The specified name will be used to address the DBTable element from scripts, so, the name must be a valid script identifier. Scripting languages supported by TestComplete use different naming rules. In order for the name to match the name to naming rules adopted by all of the supported scripting languages, it must start with a letter and contain only letters, digits and underscore symbols.
  • In the Description box you can enter text that describes the settings and the DBTable element.

  • The Connection box displays the string that contains the settings for connecting to the desired database. To create or modify the settings, press the ellipsis button and use the subsequent standard Data Link Properties dialog.

    Note: If the connection string includes the database file name, then the settings will be computer-dependent. They may become invalid if you move the project to another computer. To avoid this problem, place the database file in a shared folder and use the network path to the file when specifying the connection settings. See also Computer-Specific Settings.
  • The Login and Password edit boxes specify the user name and password, which TestComplete will use to connect to the database.

    The name and password are stored in project files in an encrypted form.

  • Using the following option buttons you can specify the source of the data that will be stored:

    • Table - TestComplete will retrieve data from a database’s table (you will be able to specify the desired table on the next page of the wizard).

    • View - TestComplete will retrieve data from a view or query defined in the database (you will be able to specify the name of the desired view or query on the next page of the wizard).

    • Custom query - To retrieve data, TestComplete will use a custom SQL query (you will be able to enter the query code on the next page of the wizard).

See Also

Select Database Table Wizard
Creating Database Checkpoints
About Database Checkpoints
About DBTables Collection

Highlight search results