|
The Query feature of NAVIDATA provides the ability for you to specify field names to be searched, using IF/AND/OR conditioning, searching for Equal, Not Equal, Greater, Less, Contains and Not Contains.
Query also allows, if authorised, the updating of fields with values, or arithmetic on decimal fields. This provides an easy to use "Bulk Change" capability, allowing you to update, copy or delete all records matching the selection criteria.
When selecting or updating records, you may use another field for comparison or update. You may also specify any of the OPNQRYF '%' operations, such as %RANGE, etc.
The KEY statement allows you to control the sequence in which the records are displayed.
The RUN statement allows you to call a program to process the selected records.
The SET statement allows you to update fields in the selected records. Fields may to set to a constant, another field or an arithmetic expression of other fields and values.
The CPY statement allows you to copy the selected records.
The DEL statement allows you to delete the selected records.
The PRT statement allows you to print the selected records.
The XLT statement allows you to translate characters within a field dynamically expanding or contracting at the same time.
|
|
