Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 7 Answers
- 9691 Views
- Wipro, I also Faced
- E-Mail Answers
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
i am new QTP... please tell me automation frameworks , types & for whiich type of applications frameworks are used & how to generate script in keyword driven framework
What is an expert view and keyword view?
Explain advantages and disadvantages of ddf?
How can we conduct U-I Testing by using QTP??????
For QTP Test Engineer, What is his contribution to the Project? Means, As as automation test engineer what is his role in the current project?
supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?
we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?
can i change the runtime properties of an object ? How can i check if a parameter exists in database ?
QTP script is not working on other's machine..
Explain the types of object repository?
Explain how qtp identifies objects?
Consider one application is open, clicking one menu will open another application in another browser. QTP does not catch the URL of the second browser(second application). can we capture it ?
Explain how you can find length of array in qtp?
Explain about Test Fusion Report of QTP?
How to get the particular property value?
