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.
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. For more about updating
DataWindow objects, see Controlling
Updates in DataWindow objects.
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, 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.
To add a row
-
Click the Insert Row button.
PowerBuilder creates a blank row.
-
Enter data for a row.
To save the changes to the database, you must apply them, as
described below.
Adding a row in an application
Clicking the Insert Row button in the Preview view is
equivalent to calling the InsertRow method and then the ScrollToRow
method at runtime.
Selecting Insert Row is equivalent to calling the insertRow
method and then the scrollToRow method at runtime.
To delete a row
-
Click the Delete Row button.
PowerBuilder removes the row from the display.
To save the changes to the database, you must apply them, as
described below.
Deleting a row in an application
Clicking the Delete Row button in the Preview view is
equivalent to calling the DeleteRow method at runtime.
Selecting Delete Row is equivalent to calling the deleteRow
method at runtime.
To apply changes to the database
-
Click the Update Database button.
PowerBuilder updates the table with all the changes you have
made.
Applying changes in an application
Clicking the Update Database button in the Preview view is
equivalent to calling the Update method at runtime.
Selecting Save is equivalent to calling the Update method at
runtime.