Specify SQL Statements in QTP Tool in Testing

You can manually specify the database connection string and the SQL statement. First insert a Database Checkpoint, as in:

       Clipboard01.jpg

To specify SQL statements:

  1. Choose Specify SQL statement in the Database Query Wizard. The following screen opens:

    2.jpg

  2. Specify the connection string and the SQL statement and click Finish.

    3.jpg
Connection String - Enter the connection string or click create to open the ODBC select data source dialog box. You can select a .dsn file.

SQL statement - Enter the SQL statement.

       4.jpg

Quick Test takes several seconds to capture the database query and restore the Quick Test window.