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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » UltraLite Plug-in Help » Introduction to UltraLite Plug-in property sheets

Article property sheet: General tab Next Page

Article property sheet: Where Clause 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 Clause tab of the Article property sheet has the following components:

This article has the following WHERE clause    You can edit the WHERE clause in the text box to restrict the table rows that are included in the article. You do not need to include the keyword WHERE.

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

Salary > 50000
See also