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

Define Environment Variable in UFT and its uses?

0 Answers  

will QTP accepts javascript?

14 Answers   AppLabs,

VB scrip has a special command named LBound, which returns the starting index of an arry. What are the possible indexes an array can start with? options are given below. and one only the correct answer. pl select it 1. any index 2. only even non-negative 3. only 0 4. any non-negative integer

1 Answers  

What is an environment variable?

1 Answers  

can u explain relative path architecture framework in qtp?

0 Answers   Mindlance,

what is the use of VIRTUAL OBJECTS? explain ?

4 Answers  

How to connect QTP to Testdirector

4 Answers   BirlaSoft, Polaris,

Is it possible to switch between recording modes during a test creation?

0 Answers  

How to remove the associated function library?

0 Answers  

Among all the check points what is the most important checkpoint?

5 Answers   Semantic Space,

How to get all the objects count and objects names in webpage using QTP ?

6 Answers  

Hi, i have a string like "INDIA". I need to display this string vertically in Msgbox?

3 Answers