In this lesson, you use your Android application to update the UltraLite remote database and synchronize the CustDB consolidated database.
Ensure that the Employee ID field is 50, the Host field is 10.0.2.2, and the Port field is 80, and then click Save.
The application automatically synchronizes and a set of customers, products, and orders is downloaded to the application from the CustDB consolidated database.
In the simulator, click Menu » New.
In the Customer field, choose Ace Properties.
In the Product field, choose 4x8 Drywall x100.
In the Quantity field, type 999.
In the Discount field, type 25.
Click OK to add the new order.
Synchronize the application with the CustDB consolidated database.
In the simulator, click Menu and then click Sync.
Connect to the CustDB consolidated database with Interactive SQL.
Click Start » Programs » SQL Anywhere 12 » Administration Tools » Interactive SQL, or run the following command:
Click ODBC Data Source Name and choose SQL Anywhere 12 CustDB.
Verify that the synchronization was successful.
Execute the following SQL statement in Interactive SQL:
SELECT order_id, disc, quant, notes, status, c.cust_id, cust_name, p.prod_id, prod_name, price FROM ULOrder o, ULCustomer c, ULProduct p WHERE o.cust_id = c.cust_id AND o.prod_id = p.prod_id AND c.cust_name = 'Ace Properties' AND p.prod_name = '4x8 Drywall x100';
Synchronization was successful when an order entry appears in Interactive SQL.
Close the simulator window.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|