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


Please Help Members By Posting Answers For Below Questions

How did you use regular expressions in QTP and also in WR?

2153


Hi, Can we open a test in qtp10 which is saved in qtp 9.2?

1425


What is action split and the purpose of using this in qtp?

526


i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com

1452


how u will evaluate the tool for test automation?

1359






Can we create a qtp test from qc?

576


What are the benefits of qtp?

546


When Recovery scenario actually starts while testing the application?

1530


How does qtp identify the object in the application?

529


How to connect to a database?

571


How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?

1269


What are the features supported by UFT?

657


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.

2456


How do you create regression test packs?

602


What are the differences between table and db checkpoints?

525