Grid

From Lianjapedia
Jump to: navigation, search

Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.

Description

Shown below in a standalone Form. Click the image to see in a Custom Section in a Lianja Page.

Grid, Column

A grid is a container object that displays data in rows and columns, and is similar in appearance to a Browse window. A grid is also a container object that contains Column objects. A column can contain a Header object and controls. Because a grid and its columns, headers, and controls each have their own set of properties, you have complete control over each element of the grid.

Properties

This class supports the Common Properties plus the following:

Property Access (R/RW) Value Description
ActionBar RW Boolean actionBar visibility
ActiveColumn RW Numeric Currently selected column
ActiveRow RW Numeric Currently selected row
AlternatingRowColors RW Boolean Whether rows have alternating background colors
AutoPagination RW Boolean Whether grids are paginated over the table size specified in AutoPaginationSize, default is True
AutoPaginationSize RW Numeric Table size (number of records) over which AutoPagination applies, default is 1000
AutoResizeColumns RW Boolean Whether grid auto resizes to the maximum width when data is loaded
ColumnCount RW Numeric Number of columns
ContextMenu RW Character A comma separated string containing menu items, e.g. "Apples,Pears,Bananas". This works in conjunction with the rightclick event when the grid is Readonly. When the grid is rightclicked, the context menu is displayed. When a menu item is selected, the text for the menu item is passed to the rightclick delegate. Note: for editable grids, the rightclick delegate is only called when the right click happens in the top left 'button' of the grid, not in the body of the grid.
Filter RW Character Filter expression to restrict data included in the grid
GridLineColor RW Numeric Color of grid lines
GridLines RW Boolean Whether grid lines are displayed
HeaderHeight RW Numeric Column header height in pixels
KineticScrolling RW Boolean Whether kinetic scrolling is enabled, default is False. With kinetic scrolling, the user can flick in a given direction and it will continue to scroll in this direction until it is stopped either by the user or by friction. Setting KineticScrolling to true provides touch scrolling on touch aware devices and left mouse button pressed and moved scrolling on non-touch aware devices.
Pagination RW Boolean Whether grids are paginated regardless of table size, default is False
Picture RW Character Filename of background image
Readonly RW Boolean Whether grid is readonly
Recno R Numeric Current record number
RecordMark RW Numeric Whether record number column is displayed: 0 (False), 1 (True). This should be set before populating the grid and cannot be toggled.
RecordSource RW Character Source of data to which the grid is bound
RecordSourceType RW Numeric Data source type: 0 = table, 1 = alias, 4 = SQL statement
RelativeColumn R Numeric Currently selected column relative to the grid display
RelativeRow R Numeric Currently selected row relative to the grid display
RowColChange RW Numeric Type of cell movement made: 0 = no change, 1 = row change, 2 = column change, 3 = row and column change
RowColChangeClickEnabled RW Numeric Enable or disable click being called on a row or column change: 0 = disabled, 1 = enabled. From v6.0.3.
RowCount RW Numeric Number of rows
RowHeight RW Numeric Row height in pixels
Rowid R Numeric Current record number
RowSource RW Character Source of data to which the grid is bound
RowSourceType RW Numeric Data source type: 1 = table, 2 = alias, 3 = SQL statement
Scrollbars RW Numeric Scrollbars displayed: 0 = none, 1 = horizontal, 2 = vertical
StretchLastColumn RW Boolean Whether the last grid column is stretched to fill the available space
ViewMode RW Numeric View mode for split grids: 0 = grid view, 1 = form view, 2 = split view
WordWrap RW Boolean Whether text is word-wrapped

Methods

This class supports the Common Methods plus the following:

Method Args Description
ActivateCell row as Numeric, column as Numeric Select the cell at the specified row and column position
Add None Add a new record
AddColumn column as Numeric Add a column at the specified column position
AddItem data as Character Add an item
AddItems selectstatement as Character | commalist as Character | pipelist as Character | items as Array [,headers as Array[, headerwidths as Array]] Add items based on an SQL SELECT query, a comma-separated list, a pipe-separated list or an array, optionally specifying a second array with column header text and a third with column header widths
AddObject existing as Object | newobject as Character, class as Character Add an existing object or a new object, in which case the object's class must also be specified and optionally its caption
Autofit None Resize the columns to fit the grid
Cancel None Cancel data changes
Clear None Clear the grid
Columns column as Numeric Return an object reference to the specified Column
Delete None Delete the current record
DoScroll scroll as Numeric Scroll: 0 = up, 1 = down, 2 = page up, 3 = page down, 4 = left, 5 = right, 6 = page left, 7 = page right, 8 = top, 9 = bottom
First None Move to the first data record
GetItemColor row as Numeric, column as Numeric Return a color pair bg,fg for the specified cell. From v5.3.
GetRowColor row as Numeric Return a | separates list of color pairs bg,fg for the specified row. From v5.3.
Goto recordnumber as Numeric [, scroll as Numeric] Go to the specified record number.
Optionally specify the scroll position:
0 = scroll to ensure that the item is visible
1 = scroll to position the item at the top of the viewport
2 = scroll to position the item at the bottom of the viewport
3 = scroll to position the item at the center of the viewport.
Scroll argument from v5.5.
HideAllRows None Hide all rows. From v6.0.
HideRow row as Numeric Hide the specified row. Rows start from 1. From v6.0.
Item row as Numeric, column as Numeric [, value as Expression] Return the item text from the specified cell.
The optional value can be specified to update the item text.
Last None Move to the last data record. For paginated grids, move to the last record on the last page.
Next None Move to the next page
Previous None Move to the previous page
RemoveColumn column as Numeric Remove a column at the specified column position
RemoveObject existing as Object Remove the specified object
Save None Save data changes
Search searchstring as Character Search for searchstring in the currently selected column
SetItemColor row as Numeric, column as Numeric, foregroundcolor as Character, backgroundcolor as Character Set the foreground and background colors for the specified cell. (From v4.1).
SetRowColor row as Numeric, foregroundcolor as Character, backgroundcolor as Character Set the foreground and background colors for the specified row. (From v4.1).
ShowAllRows None Show all rows. From v6.0.
ShowRow row as Numeric Show the specified row. Rows start from 1. From v6.0.
Sort column as Numeric, direction as Numeric Sort data on the specified column. Data is sorted in descending order if direction < 0.
Note: Column numbers start from 0.

Events

This class supports the Common Events plus the following:

Event Args Description
afterRowColChange row as Numeric Occurs after moving column in the same row. Row numbers start from 0.
beforeRowColChange column as Numeric Occurs after data has changed and before the valid event. Column numbers start from 0.
dragDrop source as Object, x as Numeric, y as Numeric, state as Numeric Occurs when an object is dropped into the grid
dragOver source as Object, x as Numeric, y as Numeric, state as Numeric Occurs when an object is dragged over the grid
interactiveChange None Occurs after data has been changed interactively and after the valid event