how do you do database testing in qtp

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln

1391


i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

1498


Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...

1788


i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression

1025


What is a recovery scenario?

571






The hybrid framework can be implemented for any application. Is it true?

585


could any help me please, how to work on visual foxpro application using UFT

1683


How do we analyze the checkpoint results?

578


if our qtp vb Script may be Currepted then What we want do?

1481


Difference between copy to action and call to action?

589


how will load the object during runtime?

1579


I need to obtain the parent of an object programatically, so if I have: winButton("aButton") I need to obtain the parent part: window("Window1").Dialog("Dialog1") so I can programatically create a string of the full name of the object to call it with an execute statement in QTP I would like to use something like: part[1] = "window(""Window1"")" part[2] = "dialog(""Dialog1"")" so I can do: exeLine = part[1]&"."&part[2]&"."&"winButton(""aButton"")" Execute exeLine Apart from keeping a record of the window/dialog hierarchy is there a parent or path function/ command Thanks Adrian

1567


how did u use automating testing tools in ur job?

1483


What kinds of security (firewalls, encryptions, passwords, etc.) will be required and what is it expected to do? How can it be tested?

635


Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?

3271