How to database testing by manualy?in my db having 100
records when i am retriving the data from db it shows in
frent end 30 records how to find bug using QTP?plz Exp
realtimers (Chandana)
Answer Posted / ashish srivastava
Hi All,
As per your question i would like to suggest that make sure
that your are passing the same query from the from end as
you are using it in the back-end
as per the question your database having 100 records ,so
make sure that the query ur passing should not have any
"WHERE" AND JOINS statements in the query . If you have then
the Result will be filter and you will get the record
matching to the criteria in the query
FOR USING IT IN QTP PLS write the below code
Dim connect, recset
connect=CreateObject("ADODB.Connection")
recset=CreateObject("ADODB.RecordSet")
connect.Open"Provider=SQLDB1,Userid="Your ID",
Password="Your Password",Database="Your Database"
recset.open "Select Count(*) from your table name",connect
msgbox recset
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
How the exception handling can be done using quicktest professional?
This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?
What is checkpoints for qtp?
What is the syntax to call one script from another? And what can be the syntax to call one “action” in another?
write a script to verify links on any web page by using descriptive method by creating a description object (give a filter condition only link) ... need to verify expected like name by reading
What is 'sleep' in sync point?
What is CMMP and CMMH?
Which recording modes need more memory?
Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?
Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?
What is regular expression?
What is the syntax to call one action in another?
hi, can u tell me the QTP TEsting process in present real time companies?(beware of this... now a days Recording is not using,, only DP) and don't tell note book answers like step 1 spep2....like this .......post answer with professional skills in simple english words) thank u
hi frinds i need help .i have 4 + yrs exp in testing and nearly 2 yrs exp in QTP and QC .currently iam working north fast 2 yrs iam looking for job in south is there any openings plz letme know my mail id is pbre1980@gmail.com