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
can i compare two databases using QTP ?
How can I open a EXCEL file from QTP Resultviewer with reporter.ReportEvent function call. Example: Test files for details click "here". And clicking "Here" in the resultviewer will open a local EXCEL FILE.
Explain the difference between call to action and copy action?
how to find that tools work well with your existing system?
what is keyword driven testing in qtp?n how is it useful?
What are the different types of recovery operation?
Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...
What is parameter in qtp?
is there any addin for remedy user application
What are the advantages of a Hybrid framework?
Is QTP supports Unix. If yes, then how the test automation is done?
How to find a window is minimized or not
Hi All, How to Compare two strings character by character in QTP
Hoe can we do retesting using functions please give the code for it using login page
What are some test assets and related extensions of qtp?