write progamming connecting QTP to database sql? this is
question asked by interview? pls any answer this?
Answer Posted / ajit
Dim cn,rs
Set cn = createboject("ADODB.CONNECTION")
Set rs = createobject("ADODB.RECORDSET")
cn.open "DSN=D1"
rs.open "select empno,empname from emp",cn
while
rs.EOF<> TRUE
print rs(empno)&" "rs(empname)
rs.movenext
wend
cn.close
rs.close
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is ODC and GDC?
I have 5 save buttons in 5 tabs . The tabs are placed one after the other. My object repository have these added as 5 save buttons with name sav1, save 2, save 3 , save 4, save 5 .all are getting highlighted from OR but they are not getting clicked. After spying each button all the properties are same except First button Index 0 html id:=btnSaveTab1 outerhtml:=", Second button "html id:=btnSave "outerhtml:=", Third button "html id:=", outerhtml:=",
how do i know how to use tools
Do you know SQL? I know SQL but i don't have any experience...that's it..No more questions ...simply he said " you can leave for the day" ...guys prepare SQL Quires before attending interview in bank of america...
How would you export a script from one pc to another in qtp?
Is it possible to merge two object repository files in qtp?
What are table and db checkpoints?
What r the different filters in defect in quality center
terminal services client
How does qtp recognize objects in aut?
How to use transactions in qtp?
Have you done batch testing in qtp? If yes how you are doing?
What is reusable action?
What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)
Can U Explain about QTP tool from older version to latest version also its differences?