Answer / sashikanth

DIM ADDCON
DIM RECSET

SET ADDDCON = CREATEOBJECT("ADODB.CONNECTION")
ADDCON.OPEN "DSN= ;UID= ;PWD= ;"
SET RECSET = ADDCON.EXECUTE("SELECT.....)
WHILE RECSET.EOF
.........
.........
WEND
SET ADDCON = NOTHING
SET RECSET = NOTHING

Answer / baba fakruddin

'This is for Microsoft Access

dim con,rs

set con=createobject("adodb.connection")
set rs=createobject("adodb.recordset")

con.provider="microsoft.jet.oledb.4.0"

con.open "d:\testdata.mdb"
rs.open "select * from emp",con

do while not rs.eof
vbwindow("form1").vbedit("val1").set rs.fields("v1")
vbwindow("form1").vbedit("val2").set rs.fields("v2")
vbwindow("form1").vbbutton("validate").click

rs.movenext
Loop

' Oracle Connection

con.open
"provider=oraoledb.1;server=localhost;uid=scott;pwd=tiger;datbase=testdata"

Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

0 Answers  

---

Explain the keyword createobject with an example.

1 Answers  

---

is we can import the object repository from external source. if it so then how?

5 Answers  

---

Test script is generated and it is enhanced.It is required to be saved.But the disk space is insufficient.You are not permitted to delete any scripts.How are you going to save?

1 Answers   Accenture, DELL,

---

What is the limitation to XML Checkpoints?

0 Answers  

---

We have 10 page.In first page we 2 popup and next page we 3 popup window......(windows name is different)how can we handle the all the popups without using recovery scenario

3 Answers   IBM,

---

How do you send email with attachment from outlook using qtp ?

0 Answers  

---

what is the structure for the data driven framework

0 Answers   Wipro,

---

How to export data present in Datatable to an ".xls" file?

2 Answers  

---

In QTP, As a first step wht we will do before going to start a Automation....when it will be decided that we have to go for a Automatio..and who will decide to go for Automation. Any body can pls let me know.. Thanks in Advance..

1 Answers   Wipro,

---

I want to assign values in a table in my software, in first column i will give values, table is of 4x4 i.e 4 row and 4 columns, i m using VBScript in my automation work. it is a simple table for giving values.

4 Answers   TCS, Wipro,

---

Hi Guys, My Application in Microsoft Dynamic Navision, is it compitibale with QTP? if yes then let me know...

0 Answers  

---