Editing Vertex Databases

You can edit a database in the database view as follows:

• You can limit the rows to be handled by using filtering. The data is grouped on several pages.
• You can select a row and change the contents of the field. You can edit several fields at the same time. Edited database rows are marked with asterisks (*), and the edited fields are color highlighted.
• You can add, copy, or delete a row by selecting a function from the menu that opens when you click the right mouse button.
• You can save the changes you made on the page by clicking Save. You can continue editing the data on the other pages.
• Click OK when you wish to save the data and exit the database view.

Searching for a Row
Filtering Rows
Adding a Row
Copying a Row
Deleting a Row
Restoring Row Field Values

Searching for a Row

You can search for a row in the database as follows:

1. Activate a row. Click any field with the cursor.
2. Press Ctrl+F.
3. Enter the character string to be searched for in the text box.
4. Confirm by clicking OK.
5. Find the next matching character string by pressing F3.

Filtering Rows

You can limit the handled rows by defining filtering criteria on the topmost empty row. You can use one or several fields for the filtering criteria. The fields may be on different pages of the database view.

1. Enter the filtering character string in the field. You can use the wildcard characters asterisk (*), question mark (?), and hash (#). The wildcard characters correspond to the following characters:
   

   *	None or several characters of any kind.
   ?	One character of any kind.
   #	One numerical character (0..9).

   You can use the following comparison operators in the filtering criteria:

   >=	Greater than or equal to
   >	Greater than
   <=	Less than or equal to
   <	Less than
   !	Not equal to

2. Press the Enter key. The database view will now display the only the rows meeting the filtering criteria.

As a default, the filter is not case sensitive. You can enable case sensitivity as follows:

1. Activate one of the fields in the filtering criteria.
2. Right-click to open the context-sensitive menu.
3. Select Match Case in Filtering.
4. Press the Enter key.

You can restore all rows into the database view as follows:

1. Activate one of the fields in the filtering criteria.
2. Right-click to open the context-sensitive menu.
3. Select one of the following:
   • Show All - All rows are displayed, but the filtering criteria fields are not cleared. You can refilter the rows by pressing the Enter key.
   • Clear Filter - The filtering criteria fields are cleared. When you press the Enter key, all rows will be displayed.

Adding a Row

You can add a row into the database as follows:

1. Activate the row above or below which you wish to add a new row. Click any field with the cursor.

   Activate a row other than the filter row.

2. Right-click to open the context-sensitive menu.
3. Select Add Row Before or Add Row After. The new row will be marked with the plus character (+).

Copying a Row

You can copy a database row as follows:

1. Activate the row you wish to copy. Click any field with the cursor.
2. Right-click to open the context-sensitive menu.
3. Select Copy Row. The new row will be added above the original, and marked with the plus character (+).

Deleting a Row

You can delete a row from the database as follows:

1. Activate the row you wish to delete. Click any field with the cursor.
2. Right-click to open the context-sensitive menu.
3. Select Delete Row.

Restoring Row Field Values

Edited database rows are marked with asterisks (*), and the edited fields are color highlighted. You can restore the original values of the fields as follows:

1. Activate the row to the fields of which you wish to restore the values. Click any field with the cursor.
2. Right-click to open the context-sensitive menu.
3. Select Revert Field Values of Row.