Interested to Buy Any Domain ? << Click Here >> for more details...
How to display the first 3 letters in these "ABCDEFGH" using
qtp script?
- 6 Answers
- 20704 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 31 Yes | 3 No |
Answer / rajesh
MyString = "ABCDEFH"
LeftString = Left(MyString, 3)
MsgBox LeftString
| Is This Answer Correct ? | 23 Yes | 0 No |
Answer / rekha
By using simple "LEFT" function you can diaply the first 3
chars
| 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
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
| Is This Answer Correct ? | 2 Yes | 2 No |
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
| Is This Answer Correct ? | 0 Yes | 1 No |
When u r running a script , if u get a popup window that describing that u have received a mail to your outlook application. so to avoid the interference of the popup window , which recovery scenario(popup,object state,application hang,system crash) would u use ?
I have to pass all the test cases into gmail userid and password using functions please give me code thanks have anice and greate day
how will you handle the situation when object is not caputred during record?
Need one Urgent help please,for ex: first time i created Local reposory and convert that local to shared Rep and save in some where(by using Export local objetcs), unfortunately that saved repository is missed, now i want same repository,but iam not able to export the same repository second time?? i need that Repository only how to get???
Describe how Smart Identification is used
Can i run the qtp, without OBJECT REPOSTIRY...
How to export QTP results to an ".xls" file?
Explain the types of object repositorys in qtp?
can anyone proide me reading material on svit00ef27@yahoo.com please thanx in advance
Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln
what is meant by Implicit and explicit requirements?
Anybody explain me, the concept of checkpoint declaration in the QTP mainly for the Objects, Pages, Text and Tables ?
WinRunner 
