hi!

by writing scripting procedure in the TCL we can connect to the database and we can test data base and queries.

To Hari's statement I would like to add some more information:
The exact proccess which i have done was-
1)connect to the database
db_connect( query1 DRIVER {drivername};SERVER server_name;UID uidname;PWD password;DBQ database_name );

2)Execute the query
db_excecute_query( query1 write query u want to execute );
-Condition to be mentioned-

3)disconnect the connection
db_disconnect( query );

Thank u.....

will pls tell the different between smoke testing and sanity testing? given one really time example..

with Regards

Baskar

Hi

Let me explain you abt the sanity testing. sanity testing is done on the entire application to check the help screens are displaying properly? whether any button cut-off are there in the screen?

Smoke testing is done on the application to check the all functionalities are covered in the application like query button's new update delete buttons are present

Thank u

what is show topper?

Hi

By using db_connect db_disconnect we can directly connect the database without using database checkpoint

Hi All

Show Stopper is we can't test or access the application that point forward or functionaity collaps.

Prasad

Hi

I ll give u some real time explaination - show stopper....

consider tat u r testing some online transaction process

Test action \expected result

1.enter user name and password \ main web page should open to type acc no of the person whom u want to send money amount etc.....

2.Then click send \ confirmation and checklist window should open to get assurance from the user

3.click ok \ The sys should receive msg tran process completed succ..

The application may receive some runtime error in the first step itself tester may not able to excute next step(2)... (tat is he cant do further testing)

this defect is called show stopper .i mean to say high severity bug...

Question :How to test a SQL Query in winrunner?Without using check points?

Clarification : By using SQL Queries like select modify update create delete truncate etc we can use the database more effectively.

While testing using automation one option is to create a database check points like default custom&runtime.Another option is to enter the script manually into the winrunner for connecting to the database and for executing the query .Upto now we have created a script now we have to run this script .

Hi

Showstopper :Means high severity bug that bug will stop the

execution of the Application....

if any thing worng let me know

bye

satya