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
- 0 Answers
- 1577 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Hi, I am trying to automate the web application for generating Reports.I am facing issue with IE while running the script. After 4 report IE crashes.I am using QTP 9.5 with IE version 7. Can anubody give me solution for this issue. Thanks in advance-Jyotsna
In QTP where i have to concentrate more in the Interview point of View
What is meant by Environmental variables?2 types r there know…can u pls explain clearly?
How to run a test using quicktest professional?
Which scripting language used by quicktest professional (qtp)?
suppose i opened 6browsers and i want re-open the 4browser what is code for this..pls help me..
1.How recognize QTP Dyanamic Image? (suppose tha wedpage contains 3 logos..1 square 2.circle 3.rectangel)there changing at same position how to capture that)
Can we use Virtual Objects in Discriptive Programming?
Write a script to verify font style and color of a windows object using descriptive programming
what r the drawbacks and limitations of QTP?
QTP9.1 does not support to text checkpoint in Windows application? Is this correct? If this is correct, what is alternative for Text checkpoint?
How do you synchronization point through DP?
WinRunner 
