Description:
The FIND feature in Result Sets compresses the Result Set to only the rows that contain the Search String. This is probably satisfactory for most applications of this feature, but I have the need for an extension of that feature.
A script I regularly execute creates a log. The log may contain anywhere from a thousand rows to well over ten thousand rows.
When I issue a FIND on a particular string in that log, I like seeing the compressed list of rows containing the Search String, but I would then like to be able to "GoTo" any one of those rows and have the list revert to the full result set (in the order selected), but pointing to the row I choose from the FIND set.
How to repeat:
SELECT the contents of any table.
Issue a FIND of some known string within the result set.
Suggested fix:
Alternative 1 ... Add a GoTo feature, where the 'found' list reverts to the full result set (in the order selected), starting at the row I select from the 'found' list.
Alternative 2 ... Add a second FIND feature that highlights all rows in the result set containing the Search String, much as does the FIND feature in Query Browser.
