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
- 1692 Views
- I also Faced
- E-Mail Answers
How to start recording using quicktest professional (qtp)?
hai friends i already ask this question but when i post the question the alignment goes wrong .....my question is we have a WEB TABLE ....assume that web table having 3 row's and 3 column here in 2nd row 3rd column having VISIT FACEBOOK link...now i want to check the VISIT FACEBOOK link is available or not ..if it's there i want to click the link ...then how to find the web table row or column count ....don't write the excel or data table script here friends .....consider that it's a WEB TABLE do a favour ...thank's
descriptive program for a yahoo mail that is in yahoo mail suppose check box mailid subject assume it is like this format all things are in webtable the question is suppose some mail ids are there in that mailids i want to select the check box wich is before a@gmail.com and after that i want to click on delete button
How would you export a script from one pc to another in qtp?
suppose i give valid user id and password to open an web base application on qtp.how qtp will know itis a valid user id and password
How to face prjoect manager round what type of questions they will Ask ? (Chandana)
1 Answers Call Centre, Convergys, IBM,
what is the smart identification techniqu?what r the different mechanisums used in it?
Does QTP support Java Script also. Which is one is preferrable for QTP, VB script or Java script
In QTP I have a parameter in a datatable that is a sentence. I need to take the last word from the sentence and enter it into a field in a web application. How can I setup a parameter to enter in just a portion of the parameter (last word of the sentence) instead of the entire paramater (whole sentence).
i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?
hai, i am doing QTP by own. So, i am confident in checkpts,synchronization, data driven test, recovery scenarioe manager etc. but actually i don't know how all these we wil implement while we r writting code manually. when we r doing practice, while recording code is automatically generated but in real time i heard that we have to write the script.But i don't know how it is? How to write descriptive prog.? plz. tel me what r the basic things we have to know? explain how to write descriptive prog.? explain me with an example pls.......
how do u get lib files into scripting files?
WinRunner 
