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

SQL Anywhere 11.0.0 » Context-Sensitive Help » UltraLite Plug-in help » Introduction to UltraLite Plug-in properties windows

 

Publication Properties window: Articles tab

This tab has the following components:

  • Tables tab   The Tables tab lets you select tables to synchronize.

  • WHERE Clauses tab   The WHERE Clauses tab lets you type a WHERE clause to restrict the rows included in the selected table.

Each tab is described in detail below.

Tables tab

The Tables tab lets you select tables and add them to the list of articles that are included in the client database.

Available tables list   Lists all the user tables in the database you are currently connected to.

Selected tables list   Lists all the tables that are included in the publication synchronization.

  • Add   Adds the selected table in the Available Tables list to the Selected Tables list so the table is included in the publication.

  • Remove   Removes the selected table from the Selected Tables list so the table is not included in the publication.

WHERE Clauses tab

UltraLite applications can use row subsets by supplying a WHERE clause, with one exception: articles in UltraLite publications governing HotSync synchronization cannot use a WHERE clause.

The WHERE Clauses tab lets you supply a WHERE clause to restrict the rows that are included in the client database.

Articles list   Select a table from the list of tables included in the publication.

The selected article has the following WHERE clause   In the text box, type the WHERE clause for the table to restrict the rows that are included in the article. See Publishing only some rows using a WHERE clause.

See also