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
Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...
How can I find out the cursor position through QTP suppose I am keep tabbing(Pressing the tab key continuously) and stoped at a position Now I want to find out where the cursor position is
How can you write the scripts that operate on different objects depending on run-time information?
Limitations in QTP?
How many lines of code in each script of QTP?
Hi,All How to create a link in excel sheet using qtp
How many types of recording modes are there?
How to connect to a database?
How do you delete unwanted results in qtp?
How can you exit from an action?
What ate the Technologies supported by QTP?
What is Distributed testing? How does UFT support it?
How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))
What are the types of object repository in qtp?
If I change the property value at runtime is it effect is object repository?