UltraLite comes with a sample Windows client that automatically invokes the dbmlsync utility when the user issues a synchronization.
Start the applicationYou run the application against the CustDB consolidated database you started in the previous lesson.
To start the sample application and test authenticationStart the sample application.
From the Start menu, choose Programs » SQL Anywhere 12 » UltraLite » Windows Sample Application.
Enter an employee ID and synchronize.
Enter a value of 50 for the employee ID and click OK.
The application automatically synchronizes, and a set of customers, products, and orders are downloaded to the application from the CustDB consolidated database.
Add an order and synchronizeYou enter a new customer name and order details. During a subsequent synchronization, this information is uploaded to the CustDB consolidated database and the upload_insert and download_cursor events for the ULCustomer table triggers.
To add an orderFrom the Order menu, choose New.
Enter Frank DotNET for a customer name.
Choose a product, and enter the quantity and discount.
Click OK to add the new order.
You have now modified the data in your local UltraLite database. This data is not shared with the consolidated database until you synchronize.
To synchronize with the consolidated database and trigger the upload_insert eventFrom the File menu, choose Synchronize.
A message indicating the Insert successfully uploaded to the consolidated database appears.
Further reading |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |