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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite as a MobiLink client » UltraLite clients » UltraLite publications


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.


There are no prerequisites for this task.

Context and remarks

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

  1. Using Sybase Central, connect to the UltraLite database.

  2. Right-click the Publications folder, and click New » Publication.

  3. In the What Do You Want To Name The New Publication field, type a name for the new publication.

  4. Click Next.

  5. In the Available Tables list, click a table and click Add.

  6. 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.

  7. Click Finish.


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



 See also