Edit Menu

To insert, copy, paste, delete, and initialise rows in a data grid, use the tools on the toolbar below the data grid. Alternatively, right-click in the data grid and select an option from the Edit menu.

Add Row

Use the Add Row option to insert a row above the row currently selected in the grid.

Insert Row

Use the Insert Row option to insert a row above the row currently selected in the grid. The row is initialised based on the values in the current row.

Delete Row

Use the Delete Row option to delete the currently selected row. A warning message is displayed, allowing you to confirm or cancel the deletion. Once a row has been deleted it cannot be undone.

Copy (Ctrl+C)

This function copies the contents of the current field into the Windows Clipboard. Use this option in conjunction with the Paste field option to copy a value from one field to another. Simply select the source field, press Ctrl+C, select the destination field and press Ctrl+V (or use the right-click menu options).

Paste (Ctrl+V)

This function copies the contents of the Windows Clipboard into the current field. Use this option in conjunction with the Cut field or Copy field options to move or copy a value from one field to another. Simply select the source field, press Ctrl+X or Ctrl+C, select the destination field and press Ctrl+V.

To insert, copy, paste, or delete rows, right click in the row selection column to the far left of the data grid and select an option from the right-click menu.

Copy field (F5)

Select the Copy field (F5) option to copy the contents of the current field. Position the mouse cursor in another compatible field.

Paste field (F6)

Select Paste field (F6) to paste the data value you copied to that field.

Paste Field to Many (Ctrl+F6)

The Paste Field to Many (Ctrl+F6) option can be used in conjunction with the Copy Field (F5) option to paste the field row you have copied to a specified number of rows.

Copy Previous Field

The Copy Previous Field option can be used to copy down the values from a field in the previous row of the data grid.

Copy Previous Row (F10)

After adding a row, the Copy Previous Row (F10) option can be used to copy down the values from the previous row in a data grid.

This function will not copy down the content of JPEG (BLOB) fields.

Copy Row (F7)

Select the Copy Row (F7) option to copy the current row into an internal buffer. Use this option in conjunction with PasteRow to copy values from one row to another. Ensure that the source row is selected, then press F7. All non-blank fields are copied to the buffer. Now move to the destination row and press F8. Whether existing field values are overwritten or not will depend on the Overwrite Fields setting (See below).

The source row should be posted (Saved) before a cut and paste operation is attempted.

Paste Row (F8)

Select the Paste Row (F8) option to copy the contents of the internal buffer into the current row.

A row can be copied and pasted between different tables. Only fields with matching field names will be affected.

The row paste facility can also be used to populate new rows. (This feature is useful when the contents of a number of fields remain unchanged for several consecutive rows.)

With the cursor positioned on the last row in the dataset, press F7. Now press the down arrow to append a new row and press F8. This process may be repeated several times if required; however, keep in mind that at least one of the key field values will have to be changed for each row in order to prevent a key violation error. (In a grid with depth range initialisation enabled, this will happen automatically, provided that the overwrite toggle is disabled.)

The Copy Row (F7) and Paste Row (F8) options do not make use of the Windows Clipboard.

Paste Row to Many (Ctrl+F8)

The Paste Row to Many (Ctrl+F8) option can be used in conjunction with the Copy Row (F7) option, to paste the row you have copied to the rows you have currently selected in the grid.

Note that the field values in the Copy From Row will only be pasted into empty cells in the selected rows. Existing field values in the selected rows cannot be overwritten by a Paste operation.

Auto Insert (F9) 

The Auto Insert (F9) option invokes the Auto Insert Records dialog and provides a quick way of pasting several consecutive rows, using a series of values for a specified field.

Initialise Row and Initialise Many

The Initialise Row and Initialise Many options allow you to manually execute an Initialisation process while working in a data view. Using these options, a single row, or several consecutive rows, can be initialised.

The initialisation code that is programmed into the column properties of the data view is executed automatically when a new row is inserted. However, in some situations it may be beneficial to execute this code manually while the row is being edited.

Overwrite Fields (F11) 

The Overwrite Fields option (F11) applies to the row paste functions. It controls whether existing field values are overwritten when Paste Row (F8) is used.  

If the option is unchecked (the default setting), non-blank fields in the destination row are not overwritten during the pasting operation. If the overwrite option is enabled, all fields are overwritten.

However, this setting does not affect the Paste Field (F6) function, which will always overwrite existing values.

Delete all rows (CTRL + F12) 

The Delete all rows (CTRL + F12) feature makes it possible to delete all the rows in the current dataset, i.e. all the rows displayed in the data grid (including those that you can bring into view by scrolling). Keep in mind that the current set of rows may be limited by master-detail constraints or as the result of a filter.

Do not use the Delete all rows option to delete a very large number of rows as this could be extremely slow. Use a carefully worded SQL directive instead. If you wish to delete all the rows in a table, use the "Empty table" button in the Table Administration toolbox.

Save Row Changes

When you have modified the rows in a data grid, select this option to save the changes you have made.

Cancel Row Changes

You can undo the changes you have made to the data grid (since the last Save) by selecting this option.