programmable relational database
with graphical user interface
Below documentation is part of the MUIbase dictribution and is also available in PDF.
12. Search For
For record browsing you can use a search dialog to search for a specific record. The search feature uses a search pattern that you provide and checks all records for a successful match with this pattern. If it finds one then this record will be displayed in the table mask.
12.1 Search Dialog
To open the search dialog select menu item `Table - Search for'. This will open a window containing
After you have entered a search pattern and left the dialog with the `Search' button MUIbase starts searching for a matching record. The comparison of an attribute field with the search pattern is always done string based, attribute fields of non-string types are therefore converted to strings first.
If a matching record is found, it is displayed as the current record in the table mask. Otherwise a `Search pattern not found' message appears.
If you search on an attribute that is used as the first attribute for ordering and your search pattern doesn't start with a joker (`*' or `?') then an improved search algorithm (binary search) is used that makes use of the record order. This can speed up searching significantly.
12.2 Forward/Backward Search
Two further menu items allow to search for the next and the previous occurrence of the search pattern. Select menu item `Table - Search forward' for browsing to the next record that matches the search pattern, and `Table - Search backward' to go to the previous matching record.
12.3 Search Pattern Examples
Here are some search pattern examples:
This document was generated on September, 11 2016 using texi2html