Answer / manas

These script display the first 3 letters in that given
string:

Dim str , substr
str = "ABCDEFGH"
substr = mid(str,1, 3)
print substr

Answer / rajesh

MyString = "ABCDEFH"
LeftString = Left(MyString, 3)
MsgBox LeftString

Answer / rekha

By using simple "LEFT" function you can diaply the first 3
chars

Answer / gnani

Thanks a lot for your answer.
I have one more question which is asked in oracle, can you please send the answer.
Q:There are 4 columns and 10 rows, how to show the first column records using qtp script?

Answer / 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

Answer / tvs ramakrishna chowdary

'every thing is correct up to query passing
'after that follow below code
rs.open "select column_name1 from table",conn
do while not rs.EOF
msgbox rs.fields(0)'here column count stards form 0
(or)
msgbox rs.fields("column_name1")'instead of column no we
can use column name also
next

What is keyword view and Expert view in QTP?

1 Answers   Crea,

can any one tel ,using simple string a[0]=I a[1]=N a[2]=D like that it go's . . out put i need INDIA help me it's really need full ..

3 Answers   Mind Tree,

Which property do you use to retrieve or assign data into a cell in a Data Table object?

1 Answers  

CAn anybody tell me how can I use QTP to capture any video in my application?I want to see the video file opened in my application after the tests are completed in tests results.Can anybody help me?

6 Answers  

In a web site, Protocal has been changed http: to https: what is your approach?

2 Answers  

Among the 3 Recoring modes,Standard, Analog and Low Level. which one is mostly used. I know that Analog id used for Graphs, Digital Signatures and Barcoding. so, which one among the 2?

1 Answers  

HOW CAN QTP AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?

0 Answers  

How you r using QTP in u r project

1 Answers   IBM, Lehman Brothers,

Pls can anyone give me the descriptive programing script to find the number of edit boxes in a login window in flights reservation (windows application only not web). Pls anyone, very urgent

1 Answers  

how to recall a function in QTP?

3 Answers   Ordain Solutions,

What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????

0 Answers   Infotech,

how to parameterizing values from an excel sheet in Quick test professional?

1 Answers