Lesson 3: Updating data in the UltraLite database

In this lesson, you use the CustDB application to add, update, and delete data in the remote database.

Prerequisites

This lesson assumes you have completed all preceding lessons. See Lesson 1: Building and running the CustDB application.

Task

Browse orders.

Browsing orders is accomplished by using a similar method for each version of the CustDB application. By browsing an order, you are scrolling through the data in your local UltraLite database. Because customers are sorted alphabetically, you can easily scroll through the list and locate a customer by name.
1. To scroll down the list of customers, click Next.
2. To scroll up through the list of customers, click Previous.
Add an order.

Adding an order is carried out in a similar way in each version of the CustDB application. By adding an order, you modify the data in your local UltraLite database. This data is not shared with the consolidated database until you synchronize.
1. Click Order » New.
2. In the Customer list, click Basements R Us.
3. In the Product list, click Screwmaster Drill. The price of this item is automatically entered in the Price field.
4. In the Quantity field, type 20.
5. In the Discount field, type 5 (percent) and click OK.
Approve, deny, and delete orders.

Because you have authenticated your identity as user ID 50, you are a manager that can perform all the same tasks as a sales person, but you have the added ability to accept or reject orders. By accepting or rejecting an order, you change its status and add an additional note for the sales person to review. However, the data in the consolidated database is unchanged until you synchronize.
1. Approve the order for Apple Street Builders.
  1. To locate the customer, click Previous.
  2. To approve the order, click Order and then Approve.
  3. In the Note list, click Good.
  4. Click OK.
    
    The order appears with a status of Approved.
2. Deny the order for Art's Renovations.
  1. Go to the next order in the list, which is from Art's Renovations.
  2. To deny the order, click Order and then Deny.
  3. In the Note list, click Discount Is Too High.
  4. Click OK.
    
    The order appears with a status of Denied.
3. Delete the order for Awnings R Us.
  1. Go to the next order in the list, which is from Awnings R Us.
  2. Delete this order by choosing Order » Delete.
  3. Click OK to confirm the deletion.
    
    The order is marked as deleted. However, the current data remains in the UltraLite remote database until you synchronize changes to the consolidated database.

Results

Modifications to the data in the UltraLite database are saved but not synchronized with the CustDB database.

Next

Proceed to Lesson 4: Synchronizing the UltraLite database with the consolidated database.

Lesson 3: Updating data in the UltraLite database

Task

See also