How to retrieve the data from database?
Answers were Sorted based on User's Feedback
Answer / haribabu
by using data base checkpoint what ever you want to
retrieve the data
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kranthi
Hi Hari,
We can Retrieve data from database using datatable or Data
bse checkpoint
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / shyam.meghansh
Dim Dsn_conn,rs
Set objConnection=Createobject("ADODB.Connection")
Dsn_conn= "DSN=QT_Flight32;DBQ=C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight32.mdb;Driver=C:\WINNT
\system32\odbcjt32.dll;DriverId=281;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;"
objConnection.Open(Dsn_conn)
Set rs=CreateObject("ADODB.RecordSet")
Set rs=objconnection.execute(" select flight_Number from
Flights where flight_Number>20330")
rs.MoveFirst
While Not rs.EOF
Msgbox rs.fields.item("flight_Number")
rs.movenext
Wend
.................Any more question mail me
testingwithshyam@gmail.com
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / asn
dim con,cmd
set con=createobject("adodb.connection")
set com=createobject("adodb.command")
con.open"provider=sqloledb.1 or ora
oledb.1;server=servername;uid=uid;pwd=password;database=data
sourcename"
cmd.activeconnection
cmd.execute"select*from tablename"
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / narendra babu
place ur course in data table.
right click on it.select option import data from data base
Is This Answer Correct ? | 0 Yes | 1 No |
Ex : some mail name with surname Email id's there that is string fetch the particular surname only how to get particular surname all emails
If enter into interviewer room? how u introduce with him. with shakehand or waht?
hi is there any chance to change encoding the password
What is the use of ordinal identifier in qtp?
where do you store the test result?
How we can add actions in the test using QTP?
I have 5 no.of Action in my Test. Out off which i should make 3rd action as my start-up action. How should i make it?
i have string "I LIKE INDIA"..how to i get LIKE from the sting..
1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.
What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.
from where we will retrieve data for data driven tests in qtp?
hi i have one issue while selecting weblist i want show one particalur item in weblist .ex one weblist they are monday to sunday i want show the reporter like thurday in particular weblist can you help me about this thanks balaji