I would like to use a SQL query result set to validate the items in a drop down list. This is a list of offices (200+) that is reconfigured occasionally. I can step through the list and get the office names OK. So, I could compare the name to a name stored in a data sheet, but because the data is not always the same, a result set from a SQL query seems a cleaner option. I did this using winrunner; is there similar functionality in QTP? What I need to do is Select the first item in the drop down, then select the value in the first row of the query dataset - and check to see if they match... I can code most of this, it is the reading a query that I am unsure of.
reading a query? Anyways just like you said, you'll get the data from the drop down list and store them in an array, then you get the expected data from the database and store them in a recordSet object, then store the data from the recordSet into an array. After that compare the arrays.
Paste the code you can do and we'll help you with the rest.
1. LR Version: LR 9.5
2. protocol: Web (HTTP/HTML)
3. HTML-Advanced with URLs: No
4. URL mode: N/A
5. LR FP: N/A
6. VuGen Recording: New Engine
7. Web & Multimedia 1700 - Oracle E-Business 100
8. support/maintenance contract active: yes
9. Windows 2003 R2
10. Did not file