SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Template property sheet, Definition property sheet, and Site property sheet
The Site property sheet does not have an Articles tab.
The Articles tab of the Template and Definition property sheets has the following components:
Tables tab The Tables tab lets you select tables to include in your client database.
Columns tab The Columns tab lets you select columns from the tables to include in your client database.
WHERE Clauses tab The WHERE Clauses tab lets you type a WHERE clause to restrict the rows included in the article.
Each tab is described in detail below.
Publishing only some rows using a WHERE clause
The Tables tab lets you select tables and add them to the list of articles that are included in the client database.
Available tables list Lists all the base tables in the database you are currently connected to.
Selected tables list Lists all the tables that are included in the article for the client database.
Add Adds the table in the Matching Tables list to the Tables list so it is included in the article.
Remove Removes the table from the Tables list so it is not included in the article.
The Columns tab lets you select columns from tables and add them to the list of articles that are included in the client database.
Available columns list Lists the tables selected on the Tables tab. Click a table in the list to display its columns.
Selected columns list Lists all the columns that are included in the article for the client database.
Add Adds the column selected in the Available Columns list to the columns list so it is included in your articles to include in the client database.
Delete Removes the column from the Columns list so it is not included in the article.
The WHERE Clauses tab lets you supply a WHERE clause to restrict the rows that are included in the client database.
Articles list Select a table from the list of tables included in the article.
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.
For more information, see Publishing only some rows using a WHERE clause.
The WHERE clause: specifying rows