Item cannot be found in the collection corresponding to the requested name or ordinal in qtp

testing automated-tests qtp hp-uft
Girish picture Girish · Sep 30, 2014 · Viewed 56.6k times · Source

in a certain scenario, i was trying to use the select query inside QTP (More specifically QTP Using VB script) But the code is not working.

Option Explicit
Dim con,rs
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")

con.open "Driver={Microsoft ODBC for Oracle};Server=myServer; Uid=USERNAME;Pwd=PASSWORD;"
rs.open "SELECT B.STATUS FROM STUDENT B WHERE B.BATCHCODE='FIRST' ",con

Do while not rs.eof
DataTable.GlobalSheet.AddParameter.RawValue = rs.fields("v1")
rs.movenext
Loop

Release objects
Set rs= nothing
Set con= nothing

Please help me knowing which section of the code is getting script result fail.

Answer

vins picture vins · Oct 11, 2014

"Item cannot be found in the collection corresponding to the requested name" - this error comes when the field is not present in the recordset which you are trying to refer to!

rs will not have "v1" and it has only "STATUS".

  rs.fields("v1")

So, it should be 

rs.fields("STATUS")

Related questions

How do you write your QTP Tests?

I am experimenting with using QTP for some webapp ui automation testing and I was wondering how people usually write their QTP tests. Do you use the object map, descriptive programming, a combination or some other way all together? Any …

Read More
Automated testing for iPhone

I know this one is going to be a long-shot, but I thought I'd try. Does anyone know of any automated test anything for the iPhone simulator? I'd love it if there was something like Selenium but for the iPhone …

Read More
Unit Testing bash scripts

We have a system that has some bash scripts running besides Java code. Since we are trying to Test Everything That Could Possibly Break, and those bash scripts may break, we want to test them. The problem is it is …

Read More