Use SQL Queries

Up a level to ..

Save and Reuse Queries

 

Share Data Between Drawings and Applications > Access External Databases > Use Queries to Filter Database Information > 

Combine Queries

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To use Link Select

1. In the dbConnect Manager, in the tree view, right-click a link template. Click Link Select.
2. Select the Select option from the Do list.
3. Select a link template from Using.
4. Select one of the following options:
   • Use Query. Constructs a query using one of the tabs in the Query Editor.
   • Select in Drawing. Closes the dialog box temporarily so that you can select graphical objects in the drawing. When you select the Select in Drawing option, the Execute button changes to Select.
5. Click either Execute or Select to add your query or graphical object selection set to the Link Select operation.
6. Select a Link Select operation from the Do list: Union, Intersect, Subtract A-B, or Subtract B-A.
7. Repeat steps 3 through 5 to add set B to the Link Select operation.
8. Select one or both of the following options and click Finish to complete the Link Select operation:
   • Indicate Records in Data View. Returns the results of the current Link Select operation in the Data View window when you click Finish. You can perform further Link Select iterations by clicking the Return to Link Select button in the Data View window.
   • Indicate Objects in Drawing. Creates a selection set of linked graphical objects in the drawing area when you click Finish. You can perform further Link Select iterations by pressing ENTER at the command prompt.