Interested to Buy Any Domain ? << Click Here >> for more details...
how we do database testing with qtp using descriptive
programming?
- 22 Answers
- 38473 Views
- Nutrins, Rohit Technologies, Symphony, Syntel, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Hey guys......sorry if anybody is hurt....even my english
is not that good.....but i was searching for answer and
when i read this, it was frustrating to read .....maybe
Chandra is very good at QTP....mine was just a natural
reaction.........
Sorry Chandra....but answer in such a way that people can
understand
Now all of you please end this and give a correct answer..
Sirisha...has done nice job explaining...
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / ritesh
Just looked into the comments posted and found that
visiting this forum is a waste of time where instead of
answers people are busy contradicting each others statements
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / harikrishna
Database testing is all about data validation & data integration.The correctness of new data insertion is called data validation.
The correctness of changes incurred due to insertion of new data from parent table to child tables is called data integrity
All we have to know is DML(select,insert,update,delete) commands in sql to use to dbase testing
ADODB-we use this to connect to any kind of dbase(sql,oracle..etc)
rso(Record set object)-a temp buffer where we use to store for retriving information frm dbase.
here am posting an example hw to connect a dbase and count no.of rows in a table via qtp
Option explicit
Dim cono,rso,n
Set cono=createobject("ADODB.connection")
cono.Open("DSN=hari")
Set rso=createobject("ADODB.recordset")
rso.Open "select * from harikrishnaa",cono
n=0
While rso.EOF<>true
n=n+1
rso.MoveNext
Wend
print "no of rows in record set is"&n
Set rso=nothing
Set cono=nothing
..................i used my own crated DSN.instead you shud use connection strings(which are ready available in google search engine)
HAPPY TESTING ALL.plz write comments as i hav used my time 4 u
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chandra shekhar
Thanx you Mr. k.chandra sekhar
you halpfool answering was to me...well very done.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / abk
hay guys,
I agree with dinesh.We should encourage Mr. chandra shekhar
instead of finding negative points.He tried to help us. We
all should appreciate him.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raghavendra prasad
Mr. Mukesh, It takes great amount of interest and guts to come out and try to answer a question. I have seen people of other Asian countries speak worse English. If you can't comprehend what he is trying to communicate, ask!!! Respect your country men dude.Being from a country of many languages, English just a common language used to communicate among ourselves. Respect your country men and it will be returned to you. Good luck!!
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raghavendra prasad
Anmol,
Literacy is not in language. Its in the attitude towards people. Other than that humiliating comment of yours i haven't found a single word that answers the question. Shame on you!!!
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / maharshi
any body can suggest how to remove this buttler english
question?
| Is This Answer Correct ? | 7 Yes | 10 No |
How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.
how to identify the user defind varibles? plz tell me
Explain how to use QTP to check broken links on a page?
what is difference between analog and low level recording
How to merge the two object repositories
How can we retrieve the Bug Ids which are open&Reopen in status through QTP scrit?Please find the script which i tried... Dim objBugFactory, objBug Dim BugId Set TDConnection = QCUtil.TDConnection Set objBug = TDConnection.BugFactory If QCUtil.IsConnected then Reporter.ReportEvent 0, "Connected", "Connected to server: " + QCUtil.TDConnection.ServerName + chr (13) +"Project: " + QCUtil.TDConnection.ProjectName + chr (13) + "Domain: " + QCUtil.TDConnection.DomainName Reporter.ReportEvent 0, "Current time on server is","==>" & TDConnection.ServerTime Else Reporter.ReportEvent 1, "Not connected", "Not connected to Quality Center" End If If mybug.Status="Open" Then BugId=mybug.DefectId MsgBox BugId End If 'OR**********************************--------------------- -----********************************** If Bug_Fields("BG_STATUS").Value ="Open" Or "Re Open"Then BugId=Bug_Fields("BG_BUG_ID").Value MsgBox BugId End If
How will internal and external links be validated and updated? how often?
What are the main features we have to compulsory test by using qtp in an web based application
Write a function which returns the addition of two numbers. give the value of the numbers outside the function.
What are the environment variables?
how much space occupies in object respository by default?
How many regression test suits in your appliction?
WinRunner 
