how we do database testing with qtp using descriptive
programming?
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 can we parameterize our test, values in flat file. Ex:- Values in notepad, with that values i want to parameterize the test.
can some one help me how to compare the values from one sheet to values in another sheet? suposse i have a feild called Temp in action1 and i also have temp in action2. i want to compare the values of those two actions sheets data table? how can i do it using descriptive programming?
By default Action1 runs first in QTP. Is it possible to start the run with Action2?
What is the difference between Functions and Action ?
i am new to qtp i do not know how to write script how to write the code to login if it fails how to able error messages
How to create runtime property for an object?
Can any body tell me what is the method to connect the remote desk top throw QTP 9.2 version?
Hi my name is mohan. I am working as a manual tester.. And now i want learn QTP.. is there any online websites to learn QTP for free if u know any plz help me out..,.or send mail to k.mohann.mohan@gmail.com
Hi everybody.. I m using QTP 9.2 version., plz send me licence key is it seat or concurrent licence key... plzzzzzzzzz plz help me for this one and its Locking code:8-5C740 Maintenance number: 0123-2820602186.,
what is error and fault in terms of software quality?
Why qtp the best testing tool?
Difference between image checkpoint and bitmap checkpoint