I could not define and use a Database Output value for my purpose. Or I do not know how to do it.
This is my insight
1. Using Output Value
Every Output value, even if there exists multiple rows as a result of the select query, map/point always to a new column in the first row of the data table. So this would correspond to only one iteration of the test (no matter how many rows we get as a result of our SQL query).
I was expecting something like, if I get 5 rows as a result of my database query, correspondingly I would like to map each row to a row in the data-table and I would like to have 5 iterations in the test.
2. Using data-sheet import from database
Also when I try to use the import feature in data-sheet, it is static. So next time I run, I have to redo import to get the latest data.
This kind of concludes like, the only way to map each result row of sql query to a row in data-table is through descriptive (script) programming.
Since I am new to QTP, please advise me if I am missing anything
Thanks
This is my insight
1. Using Output Value
Every Output value, even if there exists multiple rows as a result of the select query, map/point always to a new column in the first row of the data table. So this would correspond to only one iteration of the test (no matter how many rows we get as a result of our SQL query).
I was expecting something like, if I get 5 rows as a result of my database query, correspondingly I would like to map each row to a row in the data-table and I would like to have 5 iterations in the test.
2. Using data-sheet import from database
Also when I try to use the import feature in data-sheet, it is static. So next time I run, I have to redo import to get the latest data.
This kind of concludes like, the only way to map each result row of sql query to a row in data-table is through descriptive (script) programming.
Since I am new to QTP, please advise me if I am missing anything
Thanks