Table Checkpoint is used to verify cell data within a table.
Use of Table Checkpoints: For example, taking HP Flight Simulation program contains a table listing all available flights from New York to San Francisco. We can add a table checkpoint to check that the time of the first flight in the table is correct. Table Checkpoints can be added for WebTable as well as WinTable object.
Verifies the property value of different types of object such as push buttons, radio buttons, and list boxes in your application or Web page. For example, we can verify whether a push button is enable, or a radio button is checked using standard checkpoint. (more…)
Why TestIteration?
A good use of “TestIteration” built in environment variable would be if you want to execute a specific section of Sceipt based on the number of Iteration. For example, if the test runs the first iteration we want to execute Function A and 2nd iteration Function B. (more…)
Here are some useful VBScript functions. These functions are not application related but very general. The functions description are written on the header. The functions are, random nmber generator, finding difference between two date, return a row number of an excel file with matching value. (more…)
Sometime there could be multiple object repositories in a test. It is possible the scripts or reusable actions browse through multiple application, and each apps has separate object repository. One of the problem with QTP8.2, we cannot associate multiple repositories at the same time.
(more…)
Sometimes writing result files for automation using Quick Test Pro (QTP) using VB Scripts is necessary. There are many different ways to produce result files using Automation tools, and QTP comes with a very user friendly test result. (more…)
Date related inputs are troublesome sometimes. While automating a screen that accepts dates (month, day, year) may require different formats and inputs. I was having an issue with day and month inputs when valid format was MM or DD. If you read the month and day from the system it returns a single digit month or day, but the application does not accept a month 6 (June) instead requires 06.
(more…)
Lets take a scenario when you have to match a column value or a row from a object class of wintable or webtable. The checkpoints or output value may not be effective, and getROProperty does not work in those situation. The best way is to scan the winTable each row by row and columns, and match with the expected value. We may use reporterEvent to send result to the Quick Test Pro (QTP) test result file. The method getCellData() is used to retrieve the column value. (more…)
Regular expression is mostly use to solve the dynamic object problem in Quick Test Pro. There are two ways to do those are using Object Repository and descriptive programming. But this post address a separate issue we may solve through regular expression and VB script for QTP tests. There some situation when we have to verify certain data from WebTable object. One situation was to verify status but the data position on the table cell is unpredictable. The text data also may vary but cotains certain words. To match table cell data the code scan by the rows of the table and find a match of the data. If the text does not have exact match it still return the value. (more…)
Issue: Error Message: ODBC driver does not support the requested properties.
Reason: The above error message shows up in QTP if the SQL statement is not properly written in VBScript/ QTP.
Solution: Write SQL statement properly using right format. Special care required for statement that uses parameter values. The following example executes an query that accepts parameter app (application) and env (environment) to search for user name and password from login table. I had difficulties with the sql statement and i was receiving the error message. Here is the right format and syntax. (more…)