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 | 757
5 Select one or both of the following:
■ Indicate Records in Data View. Highlights records that match your
query in the Data View window.
■ Indicate Objects in Drawing. Highlights objects that match your
query in the current AutoCAD drawing.
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.
A subset of records that match your query criterion are displayed in the
Data View window. To return to the Query Editor to refine your query,
choose the Return to Query button.
To construct a range query
1 Open the Query Editor as described in “To open the Query Editor” on page
754.
2 Choose the Range Query tab.
3 Select a field from the Field list.
4 Enter a value in From, or choose Look Up Values (From).
Look Up Values displays a list of all values for the specified field from the
database table, so you can select the value that you want. After selecting a
value, choose OK.
The query searches for all values greater than or equal to the value that
you specify.