UltraLite can maintain primary key uniqueness using any of the techniques supported by MobiLink. See Maintaining unique primary keys.
One of these methods is to use a global ID. The global ID affects how the GLOBAL AUTOINCREMENT column values are generated. You need to use columns declared as GLOBAL AUTOINCREMENT when a MobiLink server must manage synchronizations for multiple clients.
GLOBAL AUTOINCREMENT is similar to AUTOINCREMENT, except that the domain is partitioned. UltraLite supplies column values only from the partition assigned to the database's global ID.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|