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.

Changing input language

You (and your users) can add or modify data in a DataWindow object in multiple input languages. If you use multiple input languages, you can display a Language bar on your desktop to change the current input language. In a DataWindow object, the input language in effect the first time a column gets focus becomes the default input language for that column. If you subsequently change the input language when that column has focus, the new input language becomes the default for that column. This behavior does not apply to columns that have the RightToLeft property set.

NoteIf 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. For more about updating DataWindow objects, see Chapter 5, “Controlling Updates in DataWindow objects.”

StepsTo modify existing data:

  1. 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, either in the Database painter or in this particular DataWindow object.

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

StepsTo add a row:

  1. Click the Insert Row button.

    DataWindow Designer creates a blank row.

  2. Enter data for a row.

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

StepsTo delete a row:

  1. Click the Delete Row button.

    DataWindow Designer removes the row from the display.

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

StepsTo apply changes to the database:

  1. Click the Update Database button.

    DataWindow Designer updates the table with all the changes you have made.

NoteModifying data at runtime Using the toolbar buttons in the Preview view is equivalent to calling control functions such as InsertRow, DeleteRow, and UpdateData or using Button controls to perform actions at runtime.