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 a reusable action?
Give me some real time point of way where exactly we can conduct audits?
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
hi all can anyone explain how to write the code for finding the mandatory columns in table which are having (red*) (red Astrik)
Why we use QTP ,We can use other tools like WR OrSilktest What r the options in Qtp that WR and Swilktest Does not have.
Give me detailed theritical explanation about keyword driven, hybrid framework, environment variables, hybrid frame work
What is the difference between analog and low level recording?
How QTP support all types of applications (platforms)?
Hi Every body please explain me in steps to use checkpoints and object Repositories in QTP for Flight Reservation application please tell me the steps for this its urgent pls thanx for urs answers
What are the 3 main stages involved in testing with qtp?
What is the difference between call to existing action and copy of an action?
What is keyword view?
action contains public and private functions but do we resuable that action or not..If it is reusable How..plz tell me the ans
How to build scripts that access data from external sources?
what is Property......End Property loop? how to write sript for it in QTP