UltraLite User's Guide
  Tutorial: A Sample UltraLite Application

Lesson 7: Confirm the synchronization at the consolidated database

In this step, you use Interactive SQL to connect to the consolidated database and confirm that the changes made have been synchronized. This step is independent of the platform on which your UltraLite application is running

To confirm that the changes are synchronized to the consolidated database

1. Connect to the consolidated database from Interactive SQL.

   In the Interactive SQL Connect dialog, choose the UltraLite 9.0 Sample ODBC data source.

2. Confirm the status change of the approved and denied orders.

   To confirm that the approval and denial have been synchronized, issue the following statement.

   SELECT order_id, status
   FROM ULOrder
   WHERE status IS NOT NULL

   The results show that order 5100 is approved, and 5101 is denied.

3. Confirm that the deleted order has been removed.

   The deleted order has an order_id of 5102. The following query returns no rows, demonstrating that the order has been removed from the system.

   SELECT *
   FROM ULOrder
   WHERE order_id = 5102

The tutorial is now complete.