UltraLite Database User's Guide
Tutorial: Walking Through a Sample UltraLite Application
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
Connect to the consolidated database from Interactive SQL.
In the Interactive SQL Connect dialog, choose the UltraLite 9.0 Sample ODBC data source.
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.
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.