To set grid options
Select Tools | Options |Environment | Grid.
Review the following for additional information:
Show grouping panel |
Displays a panel that allows you to group data columns. Default: Cleared |
Show summary footer |
Displays a footer panel below data that lets you apply a summary function (Sum, Min, Max, Count, Avg) to a column. Default: Selected |
Automatically apply best fit to columns |
Automatically resizes data columns to maximize the amount of data that displays. Default: Selected |
Maximum rows to process |
Specifies the maximum number of rows to analyze when determining the best fit for sizing columns. Note: Increasing the number of rows provides more useful column sizes, but increases time required to retrieve data. Default: 50; -1 uses all rows |
Show navigator panel |
Displays a navigation toolbar and record count for data. Default: Cleared |
Show command panel |
Displays the date, time, and duration of the script's execution in a panel below the data. Default: Selected |
Show preview lines |
Displays a detailed preview of data for each row in the grid.
Default: Cleared |
Show line numbers |
Displays a line number for each row in the grid so you can quickly locate a record. Default: Cleared |
Show Not Null indicator |
Displays an asterisk to the right of any column headings that require a value. Default: Cleared |
Data Type Formatting |
Use this area to specify data type formats to be used when displaying values. Select a data type to format. Then select a format for that data type from the drop-down list. To customized the selected format, select the Custom check box and enter a format. Select the Custom tab to create new custom formats or review existing and pre-defined custom formats. For more information about custom formats to use with DateTime values, see "Custom Date and Time Format Strings" at http://msdn.microsoft.com/. Default (DateTime): General date/time with seconds pattern (G) |
Use locale-independent format |
Uses an invariant instead of your computer's system- defined locale for data types. This ensures that a character format, such as a decimal, is always used regardless of the character used by the computer's locale. Default: Cleared |
Submitting changes to the database |
Submits row changes (inserts, edits, and deletions) to the database:
Note: You must commit your changes to the database before closing the connection.
Default: Automatically submit row changes as they occur |
Move row focus when using horizontal navigation keys |
Moves to the previous or next row when using the left or right arrow keys on the first or last cell in a row. Default: Cleared |
Show data as read-only |
Defaults the data grid to read-only mode. See Edit Data in Read-Only Grids for more information. Default: |
Tips:
To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).
To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center