Thread: Can "Database Checkpoints" be executed in demo Flight Application

Friends,

Can "Database Checkpoints" be executed on the demo Flight Application. If yes, please illustrate them in detail. But, I did not find any database, except the notepad file which displayed the information, in a table format.

If I can't practice them on the demo application, give me an example so that I can practice the "Database Checkpoints".

I am waiting for your replies.....

Thank you,
Ravisuriya

I tried it out as below:

1. Mentioned the 'Connection String' (DSN).
2. Selected the table 'Orders'.
3. In the displayed table information, selected a Customer_Name in grid. Later, selected radio button Constant in 'Configure value' frame which had value '1'.
4. Clicked on OK in the the Database Checkpoint Properties dialog.
5. Ran the test.
6. Result was displayed as Pass.


The same I tried using by choosing radio button Parameter in 'Configure value' frame by selecting the global sheet option. The customer name was displayed in the column.

Later, I added few more names, among which were already present in the table and few which were not present.

It failed, since the login dialog descriptive program written was in search of 'Login' dialog. Since, the login dialog was not displayed, test failed.




My doubt is,

a) Whether, what I done is right ?
b) How to parameterize this for more customer name or any other column value ?
c) How to continue with the other parameter left over in the data table, for database check point ?
c) How to confirm the result of database checkpoint apart from the test result summary displayed ?

Record the flight application by inserting one record into the order table.
1). Goto insert,checkpoints,database checkpoints.
2) click the specify sql statment manually then click next.
3) Click create button then select machine data source from the toolbar,then select your database name QT_Flight32 from the list and click ok.
4) Type select * from orders in the SQL statement text box then finish.
5) select the entire table or one single row or single column from yor table.Then click ok.
6) Stop record.
7)Goto database of flight32 and delete one record from the orders table.
8)Run the application now your script should fail because you have deleted one record from the database and it will not match with the expected result.
For example if your expected result contains 20 orders and if u are deleting that record from the database your script will fail.


Please go through this and if u have any more post it.