Articles defined for UltraLite, MobiLink and SQL Remote publications use a WHERE clause to define a subset of rows of a table to be included in an article.
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 );
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|