Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 qtp window?

0 Answers  


How to add a runtime parameter to a data sheet?

6 Answers  


Tell me the difference between the Data Driven Frame work and Keyword Driven frame work?

3 Answers   Semantic Space,


In an interview what r the questions asked in qtp related project? pls any answer this question?

3 Answers  


what is automation(qtp)bug pls giv me one ex?

1 Answers  


Explain object spy in qtp.

0 Answers  


I am having major problems with some DB Table Checkpoints I add to my script. I 35 web based applications recorded and each has DB Table Checkpoints insert but only 1 script isn't recognizing the DB Table Checkpoints for some reason. I've checked the DB connections and the info in the Library Functions and still only this one script out of 35 doesn't recognize the DB Table Checkpoints. Can someone please help me figure out why only this one script out of 35 that's hitting the same database is having a problem.

0 Answers  


I have 5 save buttons in my application on 5 different tabs one after the another . I have spy them and added each of them in my OR. My Or is able to highlight each button on each of the 5 tabs. But when I run the script it does not click the object.Is there anything I have to edit in OR. Any property to add or delete? Below are the properties of 5 save buttons. My code for each is like browser().page().savebutton1.click Browser().page.savebutton2.click Properties of 5 buttons Dhopare, Namita Sent: September 2, 2015 2:57 PM To: Vullengala, Jagadeeshchandra "Class Name:=WebButton", "abs_x:=718", "abs_y:=693", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSaveTab1", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSaveTab1"" class=""Button"" onclick=""document.getElementById('a1').click();"" name=""btnSaveTab1"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=718", "y:=616" "Class Name:=WebButton", "abs_x:=687", "abs_y:=571", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSave", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSave"" class=""Button"" onclick=""document.getElementById('a2').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=687", "y:=494" "Class Name:=WebButton", "abs_x:=635", "abs_y:=478", "class:=Button", "disabled:=0", "height:=23", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a3').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=635", "y:=401" "Class Name:=WebButton", "abs_x:=695", "abs_y:=558", "class:=Button", "disabled:=0", "height:=22", "html id:=BtnExternalPartySve", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""BtnExternalPartySve"" class=""Button"" onclick=""document.getElementById('a4').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=695", "y:=481" "Class Name:=WebButton", "abs_x:=672", "abs_y:=642", "class:=Button", "disabled:=0", "height:=22", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a5').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=672", "y:=565" Previous Item Next Item Connected to Microsoft Exchange

1 Answers  


how we can know qtp has used smart identification machanism during the execution.

3 Answers   IBM,


How can i get QTP 9.2 software or any webside where i can download ? can anyone help me out , i want to be expert in QTP ,but i don't have the software

3 Answers  


what is vmodel?advantages and disadvantages of vmodel?

0 Answers   AZTEC,


Give some brief idea about a) Active x check b) Alt property check c) Applet object check d) Frame object check e) Multimedia links check f) Server side image check g) Table object check

1 Answers   CTS,


Categories