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

How QTP recognizes Objects in AUT?

8 Answers   Blue Star,

What is API?

1 Answers  

How do we do DOM programming in QTP.Could you explain with an example. If possible please provide some material or link related to DOM Programming.

0 Answers  

In ordinal identifier there r 3 options available. Which one will be enabled first when ordinal identifier is invoked.

3 Answers   Cap Gemini,

A webPage has a ComboBox with 10 values in it. Write a script to select 4 vales from it using CTRL key

3 Answers   Virtusa,

what is the syntax for regular expression in QTP? how to create user defined functions in QTP?

6 Answers   CTS, MBT, TCS,

is it possible to change the date format like MM/DD/YY into DD/MM?YY through script in QTP

5 Answers   IBM,

What is keyword view?

0 Answers  

diff between qtp versions from 8.5

0 Answers   Semantic Space,

Which scripting language QTP is using?

6 Answers  

What is difference between Recording time object identification and Run time (Execution) time.

0 Answers   Tech Mahindra,

Get the count of files of similar types from a folder.

0 Answers   Deloitte,