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
Which recording modes need more memory?
what is error and fault in terms of software quality?
Why is action split used by qtp?
If created one virtual object? Next time I changed the window position will it work?
Is it possible to call from one action to another action in qtp?
Output values? i want a practical example
Give me some real time point of way where exactly we can conduct audits?
i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji
How many ways we can parameterize data in quicktest professional (qtp)?
Can any one say what exact diff between test->parameters, action properties-> parameters. after defining the parameters in test->settings, how can we access those parameters.(i know how to use action prop parameters)
How do I lauch my test website using code from qtp in different environmet, uat and PPTE?
Hello everyone! I am just writing a small test for a windows application. I have a problem with a text output value. The value i am trying to catch is presented in a scrollable textbox. When the text is too long, only a portion of it gets captured. Do you have any experience with this?
In the Hybrid framework, data can access the database, excel file, XML etc. Is it true?
Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..
i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet