Creating a Default Check on a Database - WinRunner

When you create a default check on a database, you create a standard database checkpoint that checks the entire result set using the following criteria:

  • The default check for a multiple-column query on a database is a case sensitive check on the entire result set by column name and row index.
  • The default check for a single-column query on a database is a case sensitive check on the entire result set by row position.

If you want to check only part of the contents of a result set, edit the expected value of the contents, or count the number of rows or columns, you should create a custom check instead of a default check. For information on creating a custom check on a database, see “Creating a Custom Check on a Database,”

Creating a Default Check on a Database Using ODBC or Microsoft Query

You can create a default check on a database using ODBC or Microsoft Query.

To create a default check on a database using ODBC or Microsoft Query:

  1. Choose Insert > Database Checkpoint > Default Check or click the Default Database Checkpoint button on the User toolbar. If you are recording in Analog mode, press the CHECK DATABASE (DEFAULT) softkey in order to avoid extraneous mouse movements. Note that you can press the CHECK DATABASE
    (DEFAULT) softkey in Context Sensitive mode as well.
  2. If Microsoft Query is installed and you are creating a new query, an instruction screen opens for creating a query.
  3. If you do not want to see this message next time you create a default database checkpoint, clear the Show this message next time check box.

    Click OK to close the instruction screen.

    If Microsoft Query is not installed, the Database Checkpoint wizard opens to a screen where you can define the ODBC query manually. For additional information, see “Setting ODBC (Microsoft Query) Options”

  4. Define a query, copy a query, or specify an SQL statement. For additional information, see “Creating a Query in ODBC/Microsoft Query” or “Specifying an SQL Statement”
  5. WinRunner takes several seconds to capture the database query and restore the WinRunner window.

WinRunner captures the data specified by the query and stores it in the test’s exp folder. WinRunner creates the msqr*.sql query file and stores it and the database checklist in the test’s chklist folder. A database checkpoint is inserted in the test script as a db_check statement.

Creating a Default Check on a Database Using Data Junction

You can create a default check on a database using Data Junction.

To create a default check on a database:

  1. Choose Insert > Database Checkpoint > Default Check or click the Default Database Checkpoint button on the User toolbar.
  2. If you are recording in Analog mode, press the CHECK DATABASE (DEFAULT) softkey in order to avoid extraneous mouse movements. Note that you can press the CHECK DATABASE (DEFAULT) softkey in Context Sensitive mode as well.

    For information on working with the Database Checkpoint wizard, see “Working with the Database Checkpoint Wizard”

  3. An instruction screen opens for creating a query.
  4. If you do not want to see this message next time you create a default database checkpoint, clear the Show this message next time check box.
    Click OK to close the instruction screen.

  5. Create a new conversion file or use an existing one. For additional information, see “Creating a Conversion File in Data Junction”
  6. WinRunner takes several seconds to capture the database query and restore the WinRunner window.

WinRunner captures the data specified by the query and stores it in the test’s exp folder. WinRunner creates the *.djs conversion file and stores it in the checklist in the test’s chklist folder. A database checkpoint is inserted in the test script as a db_check statement.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

WinRunner Topics