+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: DataTable Local Sheet Identification Issue (/Thread-DataTable-Local-Sheet-Identification-Issue)
DataTable Local Sheet Identification Issue - Kiran28 - 10-21-2008
Hi,
I wrote VBScript to insert values to DataTable before the Execution of the QTP Script.
VBScript :
Code:
Dim Low
Dim High
Low=100000
High=150000
For i=0 to 4
datatable.setcurrentrow(i)
datatable.value("PriceLow",4)=Low
datatable.value("PriceHigh",4)=High
Low=Low+50000
High=High+50000
i=i+1
Next"HSearch" Action Structure:
(ActionName)Login
-->(Called ActionName)ReuseEvent
(ActionName)Search
DataTable has following Sheets:
Global,Login,ReuseEvent,Search
I am using the above VBScript to insert values in Search Sheet.
When the script is executed the values are inserted into Search Sheet. But when the QTP Script is executed it gives error message:
"Cannot identify the specified item of the PriceLow object. Confirm that the specified item is included in the object's item collection. "
Code:
"Browser("Chicago Top Condos - Real").Page("Chicago Top Condos - Real").WebList("PriceLow").Select DataTable("PriceLow", dtLocalSheet)".I have tried changeing the above code as
Code:
"Browser("Chicago Top Condos - Real").Page("Chicago Top Condos - Real").WebList("PriceLow").Select DataTable("PriceLow", 4)".
"Browser("Chicago Top Condos - Real").Page("Chicago Top Condos - Real").WebList("PriceLow").Select DataTable("PriceLow", Search)".But I am not successful in executing the script as it keeps popping message that it cannot identify the Object.
Please help me in how to get this script execute successfully.[/b]
RE: DataTable Local Sheet Identification Issue - qatestbrian - 07-13-2011
From your well documented post it looks as though the problem is in recognizing the PriceLow object not in pulling a value from the datatable.
RE: DataTable Local Sheet Identification Issue - rajpes - 07-13-2011
In my qtp,
when i value is zero, it uses first row of datatable when i value is zero and one
so you are resetting first row in 4th sheet as 100000+50000
solution: loop with i=1 (instead of 0)