You can add, modify, or delete rows. When you have finished manipulating the data, you can apply the changes to the database.
If looking at data from a view
Some views are logically updatable and others are not. For
SQL Anywhere you cannot update views containing aggregate functions,
such as COUNT(*), or a GROUP BY clause
in the SELECT statement, or views containing
a UNION operation.
To modify data:
Do one of the following:
To modify existing data, tab to a field and enter a new value.
To add a row, click the Insert Row button and enter data in the new row.
To delete a row, click the delete Row button.
When you add or modify data, the data uses the validation rules, display formats, and edit styles that you or others have defined for the table in the Database painter.
Click the Save Changes button or select Rows>Update to apply changes to the database.
