The "Find in Database Explorer" search utility locates specific text in the Database Explorer for the connected database. Use the [Ctrl] + [N] key combination to open the search dialog.
Search results are based upon the displayed section of the Database Explorer. For example, if the Forms section is displayed, the utility will search all form objects for the specified text. When the search is performed all of the columns will be scanned for the specified text. The search results can be limited based upon case sensitivity, direction, and limited columns to look in. The entry box is also a drop down, where the search history is available.
The Database Explorer offers the following sections and appropriate columns, when configured as "View as Details":
•Tables (Name, Comment, Columns, Rows, Date/Time)
•Views (Name, Comment, Columns, Date/Time)
•Stored Procedures (Name, Comment, Size, Date/Time, Version)
•Forms (Name, Main Table, Comment, Size, Date/Time, Version)
•Reports (Name, Main Table, Comment, Size, Date/Time, Version)
•Labels (Name, Main Table, Comment, Size, Date/Time, Version)
•External Forms (Name, Comment, Size, Date/Time, Version)
•Applications (Name, Date/Time, Version)
•Command Files (Name, Extension, Date/Time, Size)
An example of use would be a user requiring to locate the text "MAP" in all reports. After selecting the Reports section of the Database Explorer, the search dialog can be launched using the [Ctrl] + [N] key combination. The word "MAP" is entered and "Names and Comments" is left as is for the "Look In" field. When the "Search" button is pressed all forms containing "map" in the name and comment will be highlighted, one at a time, for easy selection. To move to the next item located in the search, press the [Enter] key.
This feature is extremely helpful for those that have databases with a significant number of tables, views, stored procedures, forms, reports, labels, external forms, applications, and command files.
Notes:
•The search will not find text in the active or selected row.
•Press the [Enter] key to move to the next item located in the search.
•To clear the history, press the [Ctrl+R] key combination.
•The search history is saved in the C:\Users\<User>\RBTI\ folder within the DBEXP.RST file.
Find in list Filter
The "Find in list" filter allows users to decrease the displayed items within the work space, to only list objects (tables, views, stored procedures, forms, reports, and labels) that match a specified criteria within the connected database and for external files (databases, external forms, applications, and command files). Use the [Alt] + [Q] key combination to place the focus within the filter.
The search results can be limited based upon case sensitivity, and the columns (names, driving table, comments) to apply the filter. The entry box is also a drop down where the search history is available. The filters are unique per object type, where each object type has its own filter history and active filters. A button is available to clear all active filters.
