Counts the number of rows that need to be uploaded for synchronization.
ul_u_long ULCountUploadRows ( SQLCA * sqlca, ul_char pub-list, ul_u_long threshold );
sqlca A pointer to the SQLCA.
pub-list A string containing a comma-separated list of publications to check. An empty string (UL_SYNC_ALL macro) implies all tables except tables marked as "no sync". A string containing just an asterisk (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.
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, UL_SYNC_ALL_PUBS, 0 );
The following call checks publications PUB1 and PUB2 for a maximum of 1000 rows:
count = ULCountUploadRows( sqlca, UL_TEXT("PUB1,PUB2"), 1000 );
The following call checks to see if any rows need to be synchronized in publications PUB1 and PUB2:
count = ULCountUploadRows( sqlca, UL_TEXT("PUB1,PUB2"), 1 );
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|