Creating Sub-Work Areas of Records

Selection by Field Contents

1. Choose  Selection  By Contents  in the maintenance screen. You get a list of all fields used.

2. Select the desired field or fields.

3. Choose Continue. You get another screen, in which you can enter the comparison value for the field or fields.

4. Enter the comparison value.

   Note

   The compare operator has the default value "=" (equality). You can display the possible compare operators for values or character strings with F4.

5. If you want to extend the selection, display the field list again with the function Append, select the desired field or the fields and choose Continue.

   If you want to add a selection condition, position the cursor on the line before the one where you want to make a selection. With the function Insert you get the field list, from which you can select the desired field.

   You can link the selections with a logical "AND" or a logical "OR". Each OR operator forms a logical search block, which can consist of several AND statements. These search blocks are visually separated when you select ENTER.

   Example

   Field1 = 001 AND (Color1)

   Field2 = xyz OR (Color1)

   Field1 = 002 AND (Color2)

   Field2 = abc (Color2)

   Note

   You can edit the selection conditions, such as move or delete. To do this, select the affected rows and call the corresponding function. You can see the available processing functions by pressing the right-hand mouse key in the dialog box.

   You delete a single condition e.g., by selecting it and then choosing Delete.

   You can delete all conditions via the function New Selection.

6. The function Choose displays all records which satisfy the specified selection conditions, for maintenance.

   Note

   The escape symbol "#" can be used for case-sensitive searches (for example, #z.#B. for "e.g.").

Select Functions

You can select single records, all records or a block of records. You can display all selected records together (  Choose  All Selected ) and process them.

You can select any number of entries on the overview screen. If you are in a detail screen, this record is handled like a selected record.

You can select several records in the following ways:

• Select single records

  Select the desired records by mouse click on the select box or F9.

  You can get an overview of all selected records with the menu function  Choose  All Selected .

• Select All Records of the entire work area or sub-work area (for example, all changed records).

  Choose  Process  Selecting  Select All .

• Selecting a block of records

  Firstly, position the cursor on the first entry of the block and choose  Edit  Selections  Select Block . Next, position the cursor on the final entry of the block and choose Select Block again.

To delete a selection, use one of the two following possibilities:

• Delete single selection

  Position the cursor on the selected record and repeat the select function (see above).

• Delete all selections

  Use the menu option  Edit  Selections  Delete All Selections .

You can perform all maintenance or display functions with the selected records (see the relevant topics below).

Select Processed Records

All processed records are stored in an internal buffer until they are saved, and they can be changed and retrieved at will. This functionality includes all inserted and deleted records. You can display processed records in this way, to check, and reverse if necessary, their changes.

You can choose the following record selections in the Selection menu:

• all changed

• all inserted

• all deleted

• all in a task (only in transport mode)

  This selection is not affected by saving.

• all not in a task (only in transport mode)

  This selection is not affected by saving.

Your entries and changes are only written to the database when you save. They are then, with the exception of the last two selections (transport mode) no longer available to the selection functions.