Publishing a subset of rows from an UltraLite table

A publication can only contain specific table rows. A WHERE clause limits the rows that are uploaded to those that have changed and satisfy a search condition in the WHERE clause.

Prerequisites

There are no prerequisites for this task.

Context and remarks

To upload all changed rows, do not specify a WHERE clause.

Task

Using Sybase Central, connect to the UltraLite database.
Right-click the Publications folder, and click New » Publication.
In the What Do You Want To Name The New Publication field, type a name for the new publication.
Click Next.
In the Available Tables list, click a table and click Add.
Click the WHERE Clauses tab, and click the table from the Articles list. Optionally, you can use the Insert window to assist you in formatting the search condition.
Click Finish.

Results

The rows that are uploaded are now limited to those that have changed and that satisfy the search condition in the WHERE clause.

Next

None.

Publishing a subset of rows from an UltraLite table

Task

See also