Article property sheet: WHERE Clause tab

SQL Anywhere Studio Help
  Adaptive Server Anywhere Help
    Introduction to property sheets
      Article property sheet

Article property sheet: WHERE Clause tab

Articles defined for SQL Remote and MobiLink 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 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 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
```

Article property sheet: WHERE Clause tab

See also