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

Syntax

This parameter is specified in the additional_parms field in the synchronization parameters. The syntax varies depending on the API you use. You can also set this parameter with ulsync.

Default

If not specified, 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:

See also

• UltraLite Synchronization utility (ulsync)
• UltraLite.NET: TableOrder property
• UltraLite C/C++: additional_parms variable
• UltraLite for M-Business Anywhere: SyncParms class

Examples

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

ulsync -c DBF=myuldb.udb "MobiLinkUid=remoteA;ScriptVersion=2;TableOrder=Customer,Sales;Stream=http"

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

ul_synch_info info;
// ...
info.additional_parms = UL_TEXT( "TableOrder=Customer,Sales" );