Database Query Search - January 1999

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.

dbtable.gif (4246 bytes)
dbquery.gif (4534 bytes)

Instructions

info.gif (10311 bytes)

Find String

In this example I entered search string 'tbladdress' then clicked 'Find String'. The string was found in the 'Load Address' query.

findstring.gif (8998 bytes)

The double vertical bars, shown in the SQL, are a carriage return and a line feed.

Find Query

In this example I entered search string 'load address' then clicked 'Find Query'. The single query was listed.

findquery.gif (8405 bytes)

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'.

listall.gif (16520 bytes)

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.

findinname.gif (16684 bytes)

Registry Entries

The application saves and retrieves search strings, the database name and other information in the registry, for example:

registry.gif (7706 bytes)

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 

Home

Updated 2006/03/11