Interested to Buy Any Domain ? << Click Here >> for more details...
how do you do database testing in qtp
- 5 Answers
- 20630 Views
- NIIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aryan
we use database checkpoints to do database testing in qtp.
database checkpoints in a test ensure that the application
successfully retrieves or inserts data into a database.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / nani4urs
Wn we have to do database testing in qtp
first we need to create ODBC Connection using DSN.
then we need to write some commands.
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / rajiv.m
In QTP, Database testing is done by inserting Database
Checkpoint. Here we can check database available in any
format like Excel, Access, SQL.... First we need to create
ODBC Connection using DSN and then we need to write some
commands. Here are some commands which are useful for
database testing. <a
href="http://www.1keydata.com/sql/sql-commands.html">SQL
Commands</a>
| Is This Answer Correct ? | 8 Yes | 3 No |
Database Testing means checking the Database informations
is available in the customer requirement or not.
Some cases DB administrators might replaces the columns or
changes some information inthe database.
Database Checkpoints is used to Test Databases.
Here we can check database available in any format like
EXcel, Access, SQL.... QTP will provide you a drivers to
connect with that and download the Data from DB. You should
be the some what familiar with the SQL Queries.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / fayaz khan
While DataBase Testing time first we get the "Data Base Design information" From developers,Here we get the information like
->Names Of the table and there columns names
->Connection Strings(DNS)
->Mapping b/w screens & Tables..
After that we connect to the Database through ADODB.And retrive the data for testing
Adodb is a vb script object to connect to database..
Anybody want to more information about database testing through QTP Please leave a mail to me ....fayazkhan505@gmail.com..
| Is This Answer Correct ? | 3 Yes | 0 No |
wht type of User defined functions or Java Releated functions Do we write in VB scripting
how to test load test and block box testing an a web based application pls give ans briefly
Explain step generator in qtp?
I need diffrences between Object Identification, Smart Identification, Regular expresion,Low-Level Recording (enables you to record on any object in your application, whether or not QuickTest recognizes the specific object or the specific operation.) I am working on Web Application. In that object caption will change dynamically. For example, consider “Save” button. On clicking save button the caption changing as “ EDIT ”. From above concept which concept I have to use here?
HI. AnyBody can explain Automation Testing Framework...Generally wht do we Intiate before going to start Automation testing process... Anybody can explain.......Thanks in advacne...
How we can do Batch testing in QTP?
what is the use of VIRTUAL OBJECTS? explain ?
How can we get a textcheckpoint in QTP9.1?
I am verifying the actual vs the input value to make sure that they been entered correctly. In the Global Sheet I have a column called Customer with the multiple names in each row and now I am trying to capture the value during runtime under the column name Customer_in_Apps. Somewhat it works but during runtime the values are being stored in each column vs each row i.e., Customer_in_Apps, Customer_in_Apps1. Automatically it add columns instead of rows. row=datatable.getsheet("Global").GetRowCount for x=1 to row datatable.getsheet("Global").SetCurrentRow(x) Window("Customer Desktop").Window("Customer Tracking (Privacy").WinObject("TreeView20WndClass").Click 92,244 runtimevalue = .VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio n") Val1=Datatable.Value("Customer",dtGlobalSheet) Val2 = Datatable.GlobalSheet.AddParameter("Customer_in _Apps",runtimevalue) If (trim(Val2)=trim(Val1)) Then Reporter.ReportEvent micPass, "Customer validation successful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &_Val2 else Reporter.ReportEvent micFail, "Customer validation unsuccessful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &Val2 End If Next
How to call a test from another test?
Could someone explain me how to work on Out put values, explain with some example on Flight Reservation. I want to insert the out put value for the order No. Please explain the steps with some example.
Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?
WinRunner 
