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 did you use regular expressions in QTP and also in WR?
Hi, Can we open a test in qtp10 which is saved in qtp 9.2?
What is action split and the purpose of using this in qtp?
i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com
how u will evaluate the tool for test automation?
Can we create a qtp test from qc?
What are the benefits of qtp?
When Recovery scenario actually starts while testing the application?
How does qtp identify the object in the application?
How to connect to a database?
How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?
What are the features supported by UFT?
I want to know can we integrate visual source safe tool with QTP and QC for our version controlling process? WE know QTP and QC 10.0 version is having the version control inbuilt in it but I want to know the merits and demerits of the inbuilt version control tool and the visual source safe tool using QTP and QC.
How do you create regression test packs?
What are the differences between table and db checkpoints?