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 Publish only some rows using a WHERE clause.