write progamming connecting QTP to database sql? this is
question asked by interview? please give sql, pl/sql related
answer?pls any answer this?
Answer Posted / rangarao
Set myconn=CreateObject("ADODB.Connectionn")
myconn.Open
("Provider=OraOLEDB.Oracle;DataSource=Your_Oracle_Database;o
SAuthent=1;")
if(myconn.state=1) Then
Set rec=myconn.Execute("query")
while rec.EOF<>TRUE
msgbox rec.fields(colname)(We can also Specify column index)
rec.MoveNext
wend
End if
rec.Close
myconn.Close
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is difference between Recording time object identification and Run time (Execution) time.
Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri
Describe synchronization point.
breef description of batch testing ?
How can we use the "CreateObject("Shell.Application")" in QTP and what is the definition and purpose of it?
In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail
What are the advantages of a Hybrid framework?
Hi,All How to create a link in excel sheet using qtp
When Recovery scenario actually starts while testing the application?
Do you know how to connect database? Can you tell me the procedures?
How does qtp identify objects in the application?
1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?
X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?
supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?
Differentiate the type of test cases which can be automated and which cannot be automated?