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

SQL Anywhere 12.0.0 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows


Article Properties window: WHERE Clause tab

The WHERE Clause tab only appears if the publication that contains the articles has a type of log scan.

Articles defined for UltraLite, 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.

This tab has the following components:

  • This article has the following WHERE clause   You can edit the WHERE clause in the window to restrict the table rows that are included in the article.

    For example, to include only the rows that contain a salary of more than $50000, type:

    WHERE Salary > 50000

 See also