Partners
Firebird Code Factory online Help
| Prev | Return to chapter overview | Next |
Working with data grid
Grid's columns correspond to the fields and rows correspond to the records. The navigation buttons at the top of the tab allow you to switch the records quickly, insert, update or delete records.
Firebird Code Factory provides two grid modes. Full grid mode allows you to group, filter and sort data in a usual way. Simple mode is provided for working with large records number. By default the grid automatically switches to the simple mode for queries that return more than 5000 records (the number can be customized in the Options dialog). For data fetching speed-up, filtering, sorting, and grouping features are not enabled in this mode.
The popup menu of the grid also provides the following additional functions: use current field value as a filter, set the field value as Null, edit BLOB (for BLOB fields see BLOB Viewer/Editor).
Data grid allows you to:
Managing data representation
You can show/hide columns using a button in the right top corner of the grid. Just check/uncheck the column in the drop-down list. To move columns, use drag-n-drop.
The grid's header popup menu allows to align column data. Use the Alignment link and select the alignment type.
You can fix grid columns to view them permanently when working with other grid data. To fix a column, choose the corresponding item from the grid's header popup menu.
There is also a possibility to display row numbers in grids. You can adjust the corresponding column to yours liking.
Sorting data
Click the column caption to sort data by the values of this column in the ascending or descending mode. To select sort order use popup menu of the column caption.
To sort data on a combination of grid columns, use the Advanced sort... link of the popup menu of the grid's header. The Advanced sorting window will be shown. Select there the columns you want to sort from the Available columns list in the order of priority. Specify the sort order if necessary and click OK.
To cancel the sorting order, press Ctrl and click on the sorted column caption.
Using aggregate functions
To get a sum of column values, a min and max value, an average column value or an amount of records, use Data Grid Footer. Select the Footer item at the grid caption's popup menu. It will be shown at the bottom of the grid. The popup menu of the footer allows you to get an aggregate function result calculated with the corresponding column values. For grouped data use Group Footers.
| Prev | Return to chapter overview | Next |
