How to test a SQL Query in Winrunner?without using DataBase CheckPoints?

Questions by psbaskar   answers by psbaskar

Showing Answers 1 - 20 of 20 Answers

hari

  • Mar 8th, 2006
 

 hi!

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

  Was this answer useful?  Yes

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");

  Was this answer useful?  Yes

baskar

  • Mar 22nd, 2006
 

   Thank u.....

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

with Regards,

Baskar 

  

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Nagendran

  • Mar 26th, 2006
 

Hi,

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

  Was this answer useful?  Yes

Prasad

  • Apr 25th, 2006
 

Hi All,

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

Prasad

  Was this answer useful?  Yes

mani

  • Jun 1st, 2006
 

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... 

  Was this answer useful?  Yes

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 . 

  Was this answer useful?  Yes

satya

  • Jul 25th, 2006
 

Hi,

 Showstopper :Means high severity bug, that bug will stop the

execution of the Application....

if any thing worng let me know

bye

satya

  Was this answer useful?  Yes

sudhakar

  • Aug 14th, 2006
 

we can test SQL Query in Win runner by recording the script after wirting the table for the particular table command.

sudhakar kolla.

If u doubts any one ask me.

09819859346.

  Was this answer useful?  Yes

sreedevi

  • Nov 27th, 2006
 

SHOW STOPPER:

Its important to fix the bug and it blocks further functionalities. after fixing this only we will go to next functionality

  Was this answer useful?  Yes

Adith

  • Jul 13th, 2007
 

db_connect("session name", Connection String)
db_execute_query("session name", SQL Query, Record_Number);
for(i=0;i<Record_Number;i++)
{
db_get_row("session name",i, rdata);
}
db_disconnect("session name");

  Was this answer useful?  Yes

babu

  • Aug 15th, 2007
 

Show stopper means in application we are not able to go further to access it for eg. if the login screen does not allow the user to enter means, you cannot go further, so it stops the entire show.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions