The Grid view includes an unusual number of options, you can get to any grid's options by rightclicking the selected folder which has a grid view, ex. Table, Query, then click Properties then click on the Options Tab of the resulting window. Following is an explanation of the options:
| · | Main/Rights - Settings controlling your rights on the data displayed in the Grid, i.e. may you see, edit, append and delete records
|
| · | Main/Options - The options include if you are able to see the Editor, Grid and Logger in the resulting data window. If configuration and SQL settings should automatically be loaded and saved for the window, if the Grid's Navigator is visible or not, if this folder uses a shared connection to the MySQL server (meaning if it shares the database folder's connection with other open tables or if it has it's own threaded connection to the MySQL server for loading data and doing updates. Also available is If the resulting data should be auto limited by the Limiter (see Grid Overview) and if the resulting data should be pulled from the MySQL in an incremental manner, i.e. records are only fetched as you scroll through the data instead of fetching it all at once. CachedUpdates enables caching all MySQL updates on the data locally until you close the Grid or Refresh the data. Threaded enables your data to be fetched in a separate thread from your main application's thus enabling you to continue working while the data is being fetched from the MySQL server, also all updates on the data will be done in a separate thread. Raw Data will force the data all to be fetched and displayed in the original MySQL format and presented to you as plain text data, thus no conversions takes place and no special default editors will be available for, for example, datetime columns. Transactions will enable "start transaction", "commit", "rollback" automatically on all updates you do on the data, while Cascading Updates means multiple SQL statements will be generates to update queries like "select * from accounts left join orders using (AccountID)" where you update columns from both tables, separate statements will be compiled to update each table separately.
|
| · | Filter - Here you can setup the MySQL format for datetime filtering as well as the maximum history list of recently used filters
|
| · | Data - Here you can enable your resulting data's limiting and how many records by default as well as if your data is filtered by default and what the filter condition is
|
| · | View - These are common options between both tabular/grid and card formats for your Grid.
|
| · | Mode determines your default layout for your data
|
| · | BestFitMaxRecordCount determines the maximum number of records used to compute a best fit request for column widths
|
| · | CellHints determines if cells whose data is too big to display, display a hint with the data in
|
| · | FocusCellOnTab determines if the tab key is used to jump from cell to cell
|
| · | FocusFirstCellOnNewRecord determines if the first cell/column when you choose to append/insert a new record
|
| · | GotoNextCellOnEnter determines if when you have finished editing a cell contents and press enter if you are autotransfered to the next column/row
|
| · | Multi select enables you to select multiple records at a time
|
| · | CellAutoHeight enables the auto height determination for cells whose data is too large to put into a single normal sized cell
|
| · | CellEndEllipsis determines if data which does not fit in a cell will be truncated with a ellipsis
|
| · | CellTextMaxLineCount determines the maximum number of lines if a cells contents gets wrapped
|
| · | Navigator determines if you will see the grid navigator
|
| · | NavigatorHints determines if the navigator buttons show hints
|
| · | Grid - These options are specific to the tabular grid layout
|
| · | FocusCellOnCycle determines if a the next cell gets selected as you cycle through them
|
| · | ColumnFiltering enables quick filtering for columns
|
| · | ColumnHiding determines if you can hide columns by dragging them to the customize dialog or outside the window
|
| · | ColumnQuickCustomizing determines if you see the quick customize buttons for columns
|
| · | DataRowSizing determines if you can resize rows heights
|
| · | GroupBySizing determines if when you click a column to sort your data will also be automatically grouped by the sorted column
|
| · | CellMultiSelect determines if you can select just an area of cells instead of complete columns or rows/records
|
| · | ColumnAutoWidth determines if the visible columns will be sized in order for them all to fit into the available window width
|
| · | Indicator determines if you will see the record indicator at the left hand side of records. The indicator is useful for showing selected records, current records and bookmarks
|
| · | GroupRowStyle determines if the Office style will be used to display grouped records
|
| · | Card - These options are specific to card type views
|
| · | CardExpanding determines if you will be able to expand and collapse cards using a specific columns.  You need to specify these columns in the Columns Tab of the Properties folder window
|
| · | CardSizing determines if you can size cards
|
| · | RowFiltering determines if you will be able to quick filter rows using drop downs next to the row captions
|
| · | RowHiding determines if rows can be hidden by dragging them to the customize dialog or outside of the window
|
| · | RowMoving determines if you can reorder the sequence of card rows using drag and drop
|
| · | EmptyRows determines if rows containing no data is automatically hidden
|
| · | RowAutoCaptionHeight determines if row captions will be auto sized to show all of their contents
|
| · | RowCaptionEndEcllipsis determines if an eclipses is shown if all of a captions contents can not fit into the available space.
|