Can You Locate Fields?

[Guest]

Hi,

There are many queries built into our database. I changed one of the fields
from Text to Yes/NO. Is there any way to conduct a search to find out how
many of the queries use that field? Not too hopeful, but I had to ask. Thanks

 

[Guest]

Try

SELECT MSysQueries.Expression, MSysObjects.Name
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId =
MSysObjects.Id
WHERE MSysQueries.Expression Like "*FieldName*"

 

[Guest]

Go to menu TOOLS - Analyze - Documenter. Click on Queries, select all, and
click on Options to select your data. Click Ok and again Ok. Click on the
icon that is a 'W' to save the results as a Word document in Rich Text Format
(RTF file extention), then search for the field name.

 

[Guest]

Thanks that works great!

Try

SELECT MSysQueries.Expression, MSysObjects.Name
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId =
MSysObjects.Id
WHERE MSysQueries.Expression Like "*FieldName*"