2004
Table Of Contents
- Contents
- Chapter 1 - Find the Information You Need
- Part 1 - The User Interface
- Part 2 - Start, Organize, and Save a Drawing
- Part 3 - Control the Drawing Views
- Part 4 - Create and Modify Objects
- Chapter 14 - Control the Properties of Objects
- Chapter 15 - Use Precision Tools
- Chapter 16 - Draw Geometric Objects
- Chapter 17 - Change Existing Objects
- Part 5 - Hatches, Notes, and Dimensions
- Chapter 18 - Hatches, Fills, and Wipeouts
- Chapter 19 - Notes and Labels
- Chapter 20 - Dimensions and Tolerances
- Part 6 - Create Layouts and Plot Drawings
- Chapter 21 - Create Layouts
- Chapter 22 - Plot Drawings
- Part 7 - Share Data Between Drawings and Applications
- Chapter 23 - Reference Other Drawing Files (Xrefs)
- Chapter 24 - Link and Embed Data (OLE)
- Chapter 25 - Work with Data in Other Formats
- Chapter 26 - Access External Databases
- Overview of Using AutoCAD with External Databases
- Access a Database from Within AutoCAD
- Link Database Records to Graphical Objects
- Use Labels to Display Database Information in the Drawing
- Use Queries to Filter Database Information
- Share Link and Label Templates and Queries with Other Users
- Work with Links in Files from Earlier Releases
- Part 8 - Work with Other People and Organizations
- Chapter 27 - Protect and Sign Drawings
- Chapter 28 - Use the Internet to Share Drawings
- Chapter 29 - Insert and View Markups
- Chapter 30 - Publish Drawing Sets
- Part 9 - Create Realistic Images and Graphics
- Glossary
- Index
Use Queries to Filter Database Information | 759
To construct a query with a single parameter on the Query Builder tab
1 Open the Query Editor as described in “To open the Query Editor” on page
754.
2 Choose the Query Builder tab.
3 Select a field from the drop-down list in the Field cell.
4 Select an operator from the Operator cell drop-down list.
5 Enter a value in the Value cell, or choose the [...] button.
The [...] button returns a list of all values for the specified field from the
database table, allowing you to select the value you want. After selecting
a value, choose OK.
6 If you want to save the query in the current drawing for future use, choose
Store.
7 Choose Execute to execute the query and close the dialog box.
To construct a query with multiple parameters on the Query Builder tab
1 Enter the first parameter of your query as described in “To construct a
query with a single parameter on the Query Builder tab” on page 759.
2 Select the appropriate And or Or operator from the Logical field.
Clicking in the Logical field inserts an And operator. Clicking the cell
again changes the value to Or.