Query Nesting - One useful feature of queries is that the query can include another 'nested' query. And the included query can include another query. One large project I worked on used lots of 'nested' queries in a database that contained more that 500 queries. It was difficult to determine where queries were used. So I wrote a VB application that searches a database for query information. I recently enhanced it adding features which make it easier to use. It becomes the tip-of-the-month.
2006/03/11 - I used this product today and noticed that it had not been updated to DAO 6.0 so I did that and posted an updated project file [vbp] in the zipped file.
Database Search Sample Database
I created a sample database which contains one table and two queries. The sample database is distributed with the application.
In this example I entered search string 'tbladdress' then clicked 'Find String'. The string was found in the 'Load Address' query.
The double vertical bars, shown in the SQL, are a carriage return and a line feed.
In this example I entered search string 'load address' then clicked 'Find Query'. The single query was listed.
List All Queries
In this example I opened database 'quikpmv3.qad' then clicked 'List All Queries'. Then did a 'Find Query' using search string 'update'.
Find in Name
In this example I entered search string 'asgnmeetingsm' then clicked 'Find in Name'. All query names containing the search string were selected and the search string is highlighted in the 'Find Next' window.
The application saves and retrieves search strings, the database name and other information in the registry, for example:
Query Search uses modRegistry.bas
The application uses modRegistry.bas to read and write to the registry. For details on RegRead/RegWrite click here.
Help Uses modConnectToWebSite
The application uses modConnectToWebSite.bas to display this page. For details on the use of that module click here.
Download VB Code
Click here to download the VB 6 Source Code [51k].
Previous Tip Tip Index Next Tip