ULCountUploadRows method

public ul_u_long ULCountUploadRows(
     SQLCA * sqlca,
    char const * pub_list,
    ul_u_long threshold
)

sqlca A pointer to the SQL.
pub_list A string containing a comma-separated list of publications to check. An empty string (the UL_SYNC_ALL macro) implies all tables except tables marked as "no sync". A string containing just an asterisk (the UL_SYNC_ALL_PUBS macro) implies all tables referred to in any publication. Some tables may not be part of any publication and are not included if the pub_list string is "*".
threshold Determines the maximum number of rows to count, thereby limiting the amount of time taken by the call. A threshold of 0 corresponds to no limit (that is, the method counts all the rows that need to be synchronized), and a threshold of 1 can be used to quickly determine if any rows need to be synchronized.

The number of rows that need to be synchronized, either in a specified set of publications or in the whole database.

Use this method to prompt users to synchronize, or determine when automatic background synchronization should take place.

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

count = ULCountUploadRows( sqlca, UL_SYNC_ALL, 0 );

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

count = ULCountUploadRows( sqlca, UL_TEXT("PUB1,PUB2"), 1000 );

The following call checks if any rows need to be synchronized in the PUB1 and PUB2 publications:

count = ULCountUploadRows( sqlca, UL_TEXT("PUB1,PUB2"), 1 );