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
- 1474 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
we have 10 automation scripts. how to call them from one main script.
what about f2&f6 function keys
What is the need and applications of learning VB script for a automation(QTP) engineer ain Realtime ?
How does qtp identify gui object?
What are the Application Functions available in QTP?
If i entered 2 columns and 4 rows inputs in DDT Like Mango fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q is How to get the 2nd column value for corresponding 1 column input in 3rd row ie, ( i need to get "veget" in messge box @ run time
how to write scripts in QTP?
how to count spaces in a given string ex: "this is jagadeesh" in QTP with simple functional script
how to get column count in datatable
Tell me the QTP Advantages and Disadvatages ?
If 2 gmail browsers are opened in our system, how to enter the mail id and password into second browser by using discriptive program?
How can i use Ordinal identifiers and Smart identification methods suppose i want to know the index no of check box
WinRunner 
