Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Client Administration » UltraLite Synchronization Parameters and Network Protocol options » Synchronization parameters for UltraLite

Sync Result synchronization parameter Next Page

Table Order synchronization parameter


Set the table order required for priority synchronization, if the UltraLite default table ordering is not suitable for your deployment.

Syntax

The syntax varies depending on the API you use. You can also set this parameter with ulsync.

Default

Null or empty to order tables based on foreign keys relationships.

Allowed values

A comma separated list of table names that lists all tables to be uploaded.

Remarks

Typically, the default is acceptable when the foreign keys on your consolidated database match the UltraLite remote and there are no foreign key cycles.

Quote tables names with either single or double quotes. For example, "Customer,Sales" and 'Customer,Sales' are both supported in UltraLite. With ulsync, you must separate table names with semicolons (;).

If you include tables that are not included in the synchronization, they are ignored.

The order of tables on the download is the same as those you define for upload.

You only need to explicitly set the table order, if your UltraLite tables:

Note

The table order you define, must ensure referential integrity. Any tables that you do not list are appropriately sorted based of the foreign keys defined in the remote database.

See also
Examples

ulsync can set this parameter as an extended synchronization parameter as follows:

ulsync -c DBF=myuldb.udb -k http -e "Username=remoteA;Version=2;TableOrder='Customer;Sales'"

UltraLite for C/C++ applications can set the parameter as follows:

ul_synch_info_a info;
// ...
info.table_order = UL_TEXT( "Customer,Sales" );