How do I get a record count on a database in a UFT GUI test?
Question ID:
106846
| ♥ 0 |
I need to get a record count for a list of items in a database.
Marked as spam
|
Posted by Answers (1)
|
Private answer
One way to do it would be to have a stored procedure that runs the query, then execute the stored procedure from UFT, like in the below code. The variable 'ra' is the record count and you can use that value to validate that there was rows deleted.. Below is the script we used: Dim con Set con=CreateObject(''ADODB.Connection'') con.ConnectionString= ''< con.Execute ''exec < con.Close Marked as spam
 Posted by Michaeldx (Questions: 17, Answers: 807) Answered on April 29, 2016 6:59 pm
|