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

SQL Anywhere 11.0.0 » UltraLite - C and C++ Programming » API Reference » UltraLite C++ API Reference » UltraLite_Table_iface class


DeleteAllRows function

bool UltraLite_Table_iface::DeleteAllRows()

Deletes all rows from table.

In some applications, you may want to delete all rows from a table before downloading a new set of data into the table. If you set the stop sync property on the connection, the deleted rows are not synchronized.

Note: Any uncommitted inserts from other connections are not deleted. Also, any uncommitted deletes from other connections are not deleted, if the other connection does a rollback after it calls DeleteAllRows function.

If this table has been opened without an index then it is considered read only and data cannot be deleted.

  • True on success.
  • False on failure. For example, the table is not open, or there was an SQL error, and so on.