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 the need and applications of learning VB script for a automation(QTP) engineer ain Realtime ?

2 Answers  

Tell me Three major differences between QTP & Winrunner?

5 Answers  

after click on compose mail how can we attached a file in qtp with vbscript code

0 Answers  

what are all the fileds present in object repository?

0 Answers   Wipro,

What is the difference between call to existing action and copy of an action?

0 Answers  

What is object repository in qtp?

0 Answers  

What is TOM in QTP?

0 Answers  

write the regular expression for date format of mm/dd/yy?

10 Answers   CTS, HCL,

Hi im new in Testing..can any one plz re-write this code SystemUtil.Run "C:\Program Files\Mozilla Firefox\firefox.exe","","C:\Program Files\Mozilla Firefox","open" ----using for loop(for i=0;i<=10;i++ )

2 Answers  

Can an action have 2 shared object repositories associated with them? In that case, if two of them contain the same object, which one will be considered?

0 Answers  

Do we get any issues if we run the test script on differentbrowsers?what are the options we need to set in QTP?

3 Answers   CTS,

Explain the concept of object repository?

0 Answers