Synchronize data thru MLSync object (for UltraLite only)

Note: The following instructions are applicable to UltraLite database only. If you are using a local SQLite database, since SQLite does not support synchronizing data via MobiLink server, you will need to write scripts to synchronize the SQLite database with the server-side consolidated database.

To synchronize the local UltraLite database with the server-side consolidated database via MobiLink server, use the PB synchronization object MLSync. For details, refer to Working with PowerBuilder synchronization objects in the SQL Anywhere online documentation.

When synchronizing the UltraLite database with the consolidated database via Mobilink, the ScriptVersion property is required, however this property does not exist in the PB MLSync object. As a replacement, you could use the sv parameter of the ExtendedOpt property, for example:

mySync_1.ExtendedOpts = "sv = test"

If you do not specify the sv parameter of the ExtendedOpt property, then PowerServer Mobile will use the value of Publication for ScriptVersion.

Please note that the MLSync object is originally designed by PB to synchronize the local database on the PC only, and the local database on the PC can only be a SQL Anywhere database, and cannot be an UltraLite database; while in iOS, the local database can only be an UltraLite database and cannot be a SQL Anywhere database, therefore, some features of the MLSync object are implemented differently by PowerServer Mobile in order to work with the UltraLite database on iOS. For details, refer to the section called “MLSync” in Supported PB Features for PowerServer Mobile.