In this lesson, you use the CustDB application to add, update, and delete data in the remote database.
This lesson assumes you have completed all preceding lessons. See Lesson 1: Building and running the CustDB application.
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.
To scroll down the list of customers, click Next.
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.
Click Order » New.
In the Customer list, click Basements R Us.
In the Product list, click Screwmaster Drill. The price of this item is automatically entered in the Price field.
In the Quantity field, type 20.
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.
Approve the order for Apple Street Builders.
To locate the customer, click Previous.
To approve the order, click Order and then Approve.
In the Note list, click Good.
The order appears with a status of Approved.
Deny the order for Art's Renovations.
Go to the next order in the list, which is from Art's Renovations.
To deny the order, click Order and then Deny.
In the Note list, click Discount Is Too High.
The order appears with a status of Denied.
Delete the order for Awnings R Us.
Go to the next order in the list, which is from Awnings R Us.
Delete this order by choosing Order » Delete.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|