There is a table with 4 columns and 10 rows, how to write the
script to display the first column records using qtp? can
anybody help me with script?
Answer Posted / manas
Dim Conn, rs, ListOfRecords, x
' Connect to the Microsoft Access Database by createing a
object
set conn=CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/DataBase1.mdb" ' ex: Name of DataBase is
DataBase1.mdb
' Retriving data from Access using the SQL Query
' Column_name1 - Suppose first column
' Table - Suppose Name of Table
set rs=CreateObject("ADODB.recordset")
rs.Open "Select Column_name1 from Table", conn
for each x in rs.Fields
ListOfRecords = ListOfRecords & x.Column_Name1 & vbCrLf
next
MsgBox ListOfRecords
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to acess a test in RSA?
Hi can anybody send me the QTP material, To my email ID: nuve1284@gmail.com ?
what is the difference between data driver & data driven and driver script?
How you can find the absolute value of the number in qtp?
What is the syntax for how to call one script from another?
How to check feasibility of the appliction?in automation testing?
hi nani my doubt is how does qtp process metrix related to software process.
what is object and child object.. explain ..if possible give some example for better understanding ..
What is the use of defining a newobject in the object repository "Define New TestOject". How to use this further. If we define new testobject, how can it recognizes the objects properties of any application.
What are the Application Functions available in QTP?
How will you handle java tree in qtp?
What is test object model in quicktest professional (qtp)?
1.explain end to end process of qc,2.how many tabs are in qc9.0,qc10.0 3.what is review, how many reviews are following in aproject 4.how will you get the requirements 5.why do we choose testing 6.how to export tc's and requirements to qc through add-ins
How do you know the location Id of an object if you know its index id?
How will you declare a variable in qtp?