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

SQL Anywhere 10.0.1 » UltraLite - C and C++ Programming » Embedded SQL API Reference

ULClearEncryptionKey function Next Page

ULCountUploadRows function


Counts the number of rows that need to be uploaded for synchronization.

Syntax

ul_u_long ULCountUploadRows (
SQLCA * sqlca,
ul_publication_mask publication-mask,
ul_u_long threshold );

Parameters

sqlca    A pointer to the SQLCA.

publication-mask    A set of publications to check. A value of 0 indicates that the entire database needs to be checked. Otherwise, you need to supply a publication mask of OR'd publications. For example:

UL_PUB_PUB1 | UL_PUB_PUB2

threshold    Determines the maximum number of rows to count, thereby limiting the amount of time taken by the call.

Returns
Remarks

Use this function to prompt users to synchronize.

Example

The following call checks the entire database for the number of rows to be synchronized:

count = ULCountUploadRows( sqlca, 0, 0 );

The following call checks publications PUB1 and PUB2 for a maximum of 1000 rows:

count = ULCountUploadRows( sqlca,
UL_PUB_PUB1 | UL_PUB_PUB2, 1000 );

The following call checks to see if any rows need to be synchronized:

count = ULCountUploadRows( sqlca, UL_SYNC_ALL, 1 );
See also