Data View and Query Options Dialog Box (Data View Window)

Controls a number of settings related to the display of linked records and objects and the processing of SQL queries.

Access Methods

Data View Options (The Data View menu is available only if you currently have a database table open in the Data View window.)

Data View buttons

The following options are displayed.

Control how linked objects are displayed in the current drawing when you select their corresponding records in the Data View window.

Automatically Pan Drawing: Pans the drawing automatically to display objects that are associated with the current selection set of Data View records.
Automatically Zoom Drawing: Zooms the drawing automatically so that all objects associated with the current record set are displayed.
Zoom Factor: Specifies a zoom factor that limits the size of the extents of the indicated object set to a defined percentage of the drawing area. The available range is 20 to 90 percent with a default value of 50 percent. A value of 50 percent means that either the height of the extents is 50 percent of the height of the window, or the width of the extents is 50 percent of the window, whichever value is less.

Control the appearance of linked records in the Data View window when their corresponding objects are selected in the current drawing.

Show Only Indicated Records: Displays in the Data View window only the record set that is associated with the current selection set. Any records not linked to the current drawing selection set are not displayed.
Show All Records, Select Indicated Records: Displays all records in the current database table. All records that are linked to the current selection set are selected in the Data View window.
Mark Indicated Records: Applies a marking color to linked Data View records to clearly differentiate them from records without links.
Marking Color: Specifies the marking color to apply to linked Data View records. The default color is yellow.

Specify options for SQL query processing.

Send as Native SQL: Issues queries to database tables in the format of the source table rather than SQL 92 format. You can use this option to issue proprietary commands in native database format.
Automatically Store: Automatically stores queries when they are executed with the current drawing.

Control the accumulation of selection and record sets.

Accumulate Selection Set in Drawing: Adds additional objects to the selection set as you select additional Data View records. If this option is cleared, the current drawing indicates a new set of objects each time you select a new set of Data View records.
Accumulate Record Set in Data View: Adds additional records to the record set as you select additional graphical objects. If this option is cleared, the Data View window indicates a new set of records each time you select a new set of graphical objects.