How to display the first 3 letters in these "ABCDEFGH" using
qtp 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 ? | 2 Yes | 2 No |
Post New Answer View All Answers
How many lines of code in each script of QTP?
How many types of actions are there in quicktest professional (qtp)?
What is checking bitmaps?
If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?
hi Friends ,willany body tell me what is the Scope for the automation Testing inht Future is their Or not And what is the Top Most Level in the testing section according the Pay scale
Explain more about the Test Fusion Report of QTP?
What is quicktest professional window?
What is Test Fusion Report in QTP?
How does qtp identify the object in the application?
Explain hybrid framework with advantages and disadvantages?
how u will evaluate the tool for test automation?
Can any suggest me what is exposure testing?
Describe function procedure in vbscript.
How to change the priorities of the recovery scenario properties?
Can we record an application running on a remote machine using qtp?