Other than using import sheet statement for importing the
data from excel sheet, is there any other method that can
be used?
Answer Posted / shann
like if ur fetching data frm data base
for each fields in recordset.fielda.count
datatable.globalsheet.Addparameters fielda.name
next
datatable.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi guys we r working in office...we write some scripts..suddenly we have a work(5min only) in out side..what will do now,,,used to system shut down or log off or lock or sleep mode,switch use or hibernate?
how do u plan test automation?
How will we compare the texts in the two word files using QTP writing the script in Descriptive Programming. Thanks
Why is Client side image is preferred over server side image?
Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?
how to do the batch testing in test director using manual testing procedure?
How to break the object spy ?
how to explain a claims and insurance project?
Explain quicktest professional testing process?
What are the advantages of Object Repository?
How will you compare keyword and expert view?
What are the recording modes in wave event?
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
What are the types of object repository in qtp?
What is qtp window?