I have written a code to fetch values fro access db and
place in the fields. Iam using GetROProperty to fetch
runtime values. Now i want to add runtime values to the
access db in field v3. please help me. Its not writting in
the db.

Option explicit
Dim con,rs,db,c
Set con=createobject("adodb.connection")

Set rs=createobject("adodb.recordset")
con.Open "Driver={Microsoft Access Driver
(*.mdb)};dbq=D:\Sales.mdb"
rs.open "select * from tax",con
Do while not rs.eof
Browser("Sales Tax Calculator").Page("Sales Tax
Calculator").WebEdit("incost").Set rs.fields("v1")
Browser("Sales Tax Calculator").Page("Sales Tax
Calculator").WebEdit("intax").Set rs.fields("v2")
c=Browser("Sales Tax Calculator").Page("Sales Tax
Calculator").WebEdit("outtax").GetROProperty("value")
rs.MoveNext
print c
Loop
Do while not rs.EOF
rs.EditMode
rs.Fields("v3").Value="3"
rs.Update
rs.MoveNext
Loop
Set rs=nothing
Set con=nothing


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More QTP Interview Questions

what is input pramater out output pramater ?i want the decrepation..?how to use in QTP?

3 Answers   Infinite Computer Solutions,


How the exception handling can be done using QTP

6 Answers  


Brief the process of testing with UFT?

0 Answers  


Explain synchronization types in QTP

2 Answers  


Does quicktest professional (qtp) is unicode compatible?

0 Answers  






What is the current version of QTP?

19 Answers  


How to check which add-ins are associated with a test in qtp?

0 Answers  


What is meant by a Check Point in UFT? Also, explain the applicable Check Points.

0 Answers  


In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer

0 Answers   Tavant Technologies,


How to find the difference between 2 dates in qtp?

0 Answers  


What are the main features we have to compulsory test by using qtp in an web based application

1 Answers  


can any one please tell me which is the best institute in Bangalore to learn QA (crash course)? Thanks

0 Answers   iFocus,


Categories