Hi friends,

I have a scenario, When user is registered his name and e-mail id is saved in database "tempuser" table, now i have to insert a database checkpoint for checking this new data.But problem is if i add a database checkpoint when editing my script, it shows only static data (which is already in table) and i don't need it all, then what will be it's dynamic query and steps using which i can verify my new data which first inserted into table and then checked in the same script.

__________________
Brijesh Jain
brijesh.tester@yahoo.co.in
http://softwaretestingexpertise.blogspot.com

why dont u use a RO property..
I guess this property is more dynamic and reliable...

Hi
Use Environment variables or datatable to retreive values for your query.Screen shots for this are attached. Then your job is simple , you just have to change values for your environmental variables/Datatable cells to change the DB checkpoint properties.

Attached Images

	SourceProp.JPG (17.5 KB, 72 views)
	ConnStrProp.JPG (18.5 KB, 58 views)

Dynamically, I think, a query is to be written. I have experience with Rational Robot and with that experience , I can say:

1) With textcheck point, we can capture login name and emailid.(combination of login name and email id is supposed to be unique.i.e two users with same login name and email id can not register twice)

2) Make the query like: select "loginname" from "temptable" where "loginname"="text captured through textcheckpoint" and "password"="password captured through textcheckpoint".

3) If query returns "loginname"="text captured through textcheckpoint", then inserted text to form have been inserted to required table "temptable'

else
inserted text not found in required table "temptable"


I think, this logic should work.

Thanks,
Debasish Pradhan,
Noida

can you tell me how to test database in QTP (hyrachially) im new to testng .
thank you

Ya i am also new to testing and the database testing some one expalin the framework of the database tesingand the the DB cehckpoint in the QTP

I know how to use database checkpoint in qtp. Press the Insert button and click on checkpoint now select database checkpoint. It will open a new window in the new window select the radio button for sql query and right the sql query to open a database table like:
select * from table1
before writing this query select your database.
U may also do some change in the database. When u run your test it will show the expected and actual result.

can you tell me how to test database in QTP im new to testng .
venki