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.
For more about updating DataWindow objects, see Chapter 20, “Controlling Updates in DataWindow Objects.”
You can make changes to data directly in the Preview view. 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 the current DataWindow object. Changes that you make to the data use the styles and formats selected for the column.
To modify existing data:
Tab to the field that has a value you want to change and enter the new value.
To save the changes to the database, you must apply them as described in “Applying changes in an application”.
Clicking the Insert Row button in the Preview view is equivalent to calling the InsertRow function and then the ScrollToRow function during execution.
To add a row:
Click the Insert Row button.
PocketBuilder creates a blank row.
Enter data for a row.
To save the changes to the database, you must apply them as described in “Applying changes in an application”.
Clicking the Delete Row button in the Preview view is equivalent to calling the DeleteRow function during execution.
To delete a row:
Click the Delete Row button
PocketBuilder removes the row from the display. To save the changes to the database, you must apply them as described in “Applying changes in an application”.
Clicking the Update Database button in the Preview view is equivalent to calling the Update function during execution.
To apply changes to the database:
Click the Update Database button.
PocketBuilder updates the table with all the changes you have made.
