Partners
ASA 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 navigate between records, insert, update, refresh and delete records. To edit BLOB columns, use BLOB Editor.Data grid allows you to:
Data Grid Modes
ASA Code Factory provides you with two grid modes: full and simple. Full grid mode allows you to group, filter and sort data in a usual way. Simple mode is provided for working with a large number of records. For speed-up of data fetching, filtering, sorting, and grouping abilities are not enabled in this mode. By default, the grid automatically switches to the simple mode for queries returning more than 5000 records (the number can be customized in the Options dialog).
Managing data representation
You can show/hide columns using a button in the left top corner of the grid. Just check/uncheck the column in the drop-down list.
To reorder 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. To select sort order (ascending or descending), 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 or a 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 |
