Query and modify

Home

4D v20.1

Query and modify

The Query and Modify command is intended for quickly finding and modifying records. Like Query by Example, it uses the current input form as a query window. You specify the query in exactly the same way as with Query by Example.

When a record or selection of records is found, 4D displays the first record in the input form for modification. When you accept the record, you are returned to the output form.

Using Query and Modify, found records are displayed in the current output form. All records within the new selection are simultaneously displayed.
Using Query and Modify, the current record of the new selection is also displayed in the current input form. Thus, you can directly replace the values as desired. If the new selection contains several records, you can click on the navigation buttons in the import form to scroll through each record and modify the values one by one.

To use Query and Modify:

In the Design environment, choose Query > Query and Modify from the Records menu.
OR
Choose Query and Modify... from the menu associated with the “Query” button in the tool bar.
4D displays the current input form as a query window. Only the Accept and Cancel buttons are enabled.
Specify your search as for a Query by example.
For more information, refer to Query by example.
Click the Accept button or press the Enter key on the numeric keypad to begin the search.
4D performs the query, sets the current selection, and displays the first record that meets the search criteria in the input form.
Click the navigation icons to move to other records in the current selection.