Articles defined for MobiLink and SQL Remote publications can use a WHERE clause to define a subset of rows of a table to be included in an article. 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.

The WHERE Clauses tab is only shown if the publication that contains the articles has a type of log scan.

This tab has the following components:

Articles list   Select an article from the list of articles 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.

The following example creates a single-article publication that includes all sales order information for sales rep number 856.

CREATE PUBLICATION pub_orders_samuel_singer
 ( TABLE SalesOrders
     WHERE SalesRepresentative = 856 );

See Publish only some rows using a WHERE clause.

See also

• The WHERE clause: Specifying rows
• Publish only some rows using a WHERE clause