Modifying data

You can add, modify, or delete rows in the Preview view. When you have finished manipulating the data, you can apply the changes to the database.

If looking at data from a view or from more than one table By default, you cannot update data in a DataWindow object that contains a view or more than one table.

To modify existing data:

Tab to the field and enter a new value.

The Preview view uses validation rules, display formats, and edit styles that you have defined for the columns, in this particular DataWindow object.

To save the changes to the database, you must apply them.

To add a row:

Select Insert Row from the Preview view’s pop-up menu.

Sybase WorkSpace creates a blank row.
Enter data for a row.
Select Save from the Preview view’s pop-up menu to save the changes in the database.

Adding a row in an application Selecting Insert Row is equivalent to calling the insertRow method and then the scrollToRow method at runtime.

To delete a row:

Select Delete Row from the Preview view’s pop-up menu.

Sybase WorkSpace removes the row from the display.
Select Save from the Preview view’s pop-up menu to save the changes in the database.

Deleting a row in an application Selecting Delete Row is equivalent to calling the deleteRow method at runtime.

To apply changes to the database:

Select Save from the Preview view’s pop-up menu.

Applying changes in an application Selecting Save is equivalent to calling the Update method at runtime.