I have huge data for which I need to do some testing. But iterating each time through it cause me lots of time. And my execution time becomes bottleneck.
Is there any way to fire sql query on the QTP datasheet.
Or the..way...to implement...hash table....
So that we can have key value pairs....easy to..iterate throught he table....
Automation Test Engineer
We can fire sql query, sql is a language used to communicate with the database.
retrieve the value using
Sorry i mispelled, i think we can't fire sql against excel sheet.
I am not sure if you can fire SQL query on the DT Sheet
of QTP. But it is possible to access a general XL sheet
with SQL queries.
Try the following link. Hope this works...
- Devaraj R
Look at 'Dictionary objects' for Key value pair kind of mode.
Otherwise, export the sheet and use 'ADO' against the exported excel(noted in the previous post)
-- Here to Learn and share ---