Searching on Data Elements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a raft of different queries that are all in a Production state. My
upper management has made some decisions that will necesitate me changing
some of these queries. The problem is how can I easily locate all queries
that use a certain element of a certain table? I really would hate to have
to go through all the queries manually as I probably would miss one.

Thank you for your assistance!
Kent
 
Click on menu TOOLS - Analyze - Documenter and select all queries. In
options select SQL, run, and then analyze in Word. Search for the
table/field name.
 
Super! I knew there must be a way!

Thanks

KARL DEWEY said:
Click on menu TOOLS - Analyze - Documenter and select all queries. In
options select SQL, run, and then analyze in Word. Search for the
table/field name.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two New Elements 1
Counting multiple memberships 1
TimeSpan Data elements 3
Using the "Forms Object" on more than field in a query table 2
check if a product is missing? 9
Date search query 0
Left Join issues 1
Query returning data for every day of a period. 1

Back
Top