Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 19401 Views
- Oracle, I also Faced
- E-Mail Answers
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
Explain the concept of how quicktest professional (qtp) identifies object?
Output values? i want a practical example
Explain the types of properties that quick test learns while recording?
What are the ordinal identifiers in web page?
unique properties of button,edit box, radio button,check box?
What is 'sleep' in sync point?
Define Environment Variable in UFT and its uses?
what are the utilities and drivers
what is the difference betn QTP 8.0 AND PREVIOUS VERSION
Can we run test with out adding object in object repository? How it is possible?
Which environments are supported by hp qtp?
Brief the process of testing with UFT?
What are the properties you would use for identifying a browser and page when using descriptive programming?
What is parameter in qtp?
How can you close the second opened browser?
