Answer Posted / kamesh n

first connect to database using the following script


set sqlconnection=createobject("ADODB.connection")
set sqlrecordset=createobject("ADODB.recordset")

To open the connection

sqlconnection.open "You have to mention your database
connection string"

sqlrecordset.open "Give your query",sqlconnection

to run through all the records

if not sqlrecordset.EOF then


suppose your are going to set it to a textbox then

Browser(browsername).page(pagetitle).webedit
(testboxname).set sqlrecordset(columnname)


end if

when a test case is written how u test using qtp

2126

---

Can we create a qtp test from qc?

1034

---

Hi, Can we open a test in qtp10 which is saved in qtp 9.2?

1896

---

can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?

2118

---

How to capture a window in QTP?

1988

---

What Folder Structure following in Keyword Driven Frame work?

2778

---

How will we compare the texts in the two word files using QTP writing the script in Descriptive Programming. Thanks

2024

---

what is profile tool?

2235

---

How many ways is to parameterize the value?

1140

---

Diff b/w Health care domain and Banking Domain?

4703

---

Explain QTP using different development techniques ?

925

---

What is the virtual object?

1161

---

What are the advantages of parameterization ?

1068

---

Hi, I have 2 dropdown listboxes called region and city/area. It needs to select one region(Santa Clara) and one city/Area (Sunnyvale).So I put this in the for loop and I am storing the Items in the variable called itemname. The regions value will get changed,so I used reg expression for this regions. This is my code Browser("MLSListings.com").Page("MLSListings.com").Link("» County/Area").Click Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Check CheckPoint("regions") ListSize=Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetTOProperty("items count") For i = 1 To ListSize-1 Itemname =Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetItem(i+1) Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Select Itemname ................. If I run the script,I am getting the following error, Cannot identify the specified item of the regions object. Confirm that the specified item is included in the object's item collection. Any Help? Thank you, Uma

1783

---

What is a checkpoint? How many check points are there in qtp?

984

---