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.


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


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:


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


Use this function to prompt users to synchronize.


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