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:

      

To specify SQL statements:

1. Choose Specify SQL statement in the Database Query Wizard. The following screen opens:
   
   
   
   
2. Specify the connection string and the SQL statement and click Finish.
   
   
   

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.

      

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