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
What is Test Fusion Report in QTP?
how to find that tools work well with ur existing system?
Hi Samrat, Thank u very much, what u said it is right.
how to convert 100 into hundred repees only and viceversa
your coming from electrical backgroung..but y ur coming to software side?
How to find array size in qtp?
tell me QTP standards ?plz
Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay
Difference between copy to action and call to action?
How do I lauch my test website using code from qtp in different environmet, uat and PPTE?
what is error and fault in terms of software quality?
What are the Application Functions available in QTP?
Could you please any one give code for the following ? Scenario : Suppose a excel file contains 10 records and earch have 5 fields. how can i input this excel file for datadrive wizard ? Please explain
Explain features of the latest version of qtp/ uft 12.1?
what is the difference between rational rose and QTP? WHICH TOOL IS BETTER TO LEARN? PLEASE SEND ME AT sana_50218@yahoo.com sandeep@epuratech.com