|
Grids |
Top Previous Next |
|
Grids are the most efficient way to display large amounts of data and are widely used throughout Databuild
Mouse Navigation
Navigation Up/Down Arrows Move the current cell to adjacent rows. Left/Right Arrows Move the current cell to adjacent columns. Enter Behaves in the same manner as the Right Arrow key Tab moves focus to the next control on the forms PgUp, PgDn Scrolls the grid up or down an entire page at a time. Home, End Moves the current cell to the first or last column.
Selecting Rows
Rows are often selected for reports, for deleting or other functions To select one row, click in the grey selection column. The whole row will be highlighted To select additional rows, control-click in the grey selection column. That row will be highlighted also To Select a range of rows, move to the first row in the range, then shift click the last row selector. if the ALL/NONE button
Place the mouse over left or top row/column dividers and then drag and drop A lock symbol (
Filters are a very useful feature. By entering text in the yellow filter row, entries will be restricted to records that contain (or in the first column, starts with) that text in the appropriate columns. In the example above entries have been restricted to names containing "timber" Filters in the first column filter records based on the column text starting with the filter text. Other column's filters test for the filter text anywhere in the column text. To force the system to test from the start of these columns, prefix your filter text with "#" To clear selections either delete the filter text or press the delete icon next to it.
Note that you can have multiple filtered columns, but filters can only operate on text columns
Some Grids have child grids: Grids that open up below the main grid. The child grids always contain data restricted to the current row in the main grid. The key to the existence of a child is a plus sign (+) in the first column. Child grids themselves can have their own child grid.
Some grids are splittable. The key to availability is a black square in the bottom left corner of the grid
If this exists, it can be dragged to the right, creating a split grid:
The 2 split grids can be sized horizontally independently, although the rows remain synchronised. Use splits on wide grids where you want to hold a code number (say) on the left, while displaying columns on the right that would normally force the left column off the screen. |