How to display the first 3 letters in these "ABCDEFGH" using
Answers were Sorted based on User's Feedback
Answer / manas
These script display the first 3 letters in that given
Dim str , substr
str = "ABCDEFGH"
substr = mid(str,1, 3)
|Is This Answer Correct ?||30 Yes||3 No|
Answer / rajesh
MyString = "ABCDEFH"
LeftString = Left(MyString, 3)
|Is This Answer Correct ?||23 Yes||0 No|
Answer / rekha
By using simple "LEFT" function you can diaply the first 3
|Is This Answer Correct ?||12 Yes||0 No|
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?
|Is This Answer Correct ?||3 Yes||1 No|
Answer / manas
Dim Conn, rs, ListOfRecords, x
' Connect to the Microsoft Access Database by createing a
conn.Open "c:/DataBase1.mdb" ' ex: Name of DataBase is
' Retriving data from Access using the SQL Query
' Column_name1 - Suppose first column
' Table - Suppose Name of Table
rs.Open "Select Column_name1 from Table", conn
for each x in rs.Fields
ListOfRecords = ListOfRecords & x.Column_Name1 & vbCrLf
|Is This Answer Correct ?||2 Yes||2 No|
'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
msgbox rs.fields("column_name1")'instead of column no we
can use column name also
|Is This Answer Correct ?||0 Yes||1 No|
How to record object in runtime. I am testing one Image website in which every time image change on home page.so if i records the image list but during running image get change, and QTP gives error
Can i run the qtp, without OBJECT REPOSTIRY...
Using Object Repository is a advantage or disadvantage?
What are the Automation Limitations??
How many ways is to parameterize the value?
I Scheduled a QTP Script on remote desktop. Script is going to failure,when remote desktop connection fails.I have to open my remote desktop untile the scripts exection completes. If I disconnect my remote desktop connection, script is going to fail.?
What does ".mst" stands for? (abc.mst)
Diff B/w Webserver and Client Server
what is difference between wait and synchronization point.
what is KEYWORD DRIVEN TESTING ? I M NOT ASKIN WHAT IS KEY WORD VIEW PLZ ANS FOR ONLY WHAT IS KEYWORD DRIVEN TESTING EXACTLY THANX
hai friends i'm learning qtp now where we r using only record &playback frame work.and people r saying in realtime they won't use this frame work. if so what frame work actually using in realtime .and could you give explanation comaparing the record &play back fm and what ever FWyou r using in your organization. hoping cool response. thanx in advance
How can you handle exceptions in qtp?