Grid

From Lianjapedia
Revision as of 21:47, 3 April 2018 by Barrymavin (Talk | contribs)

Jump to: navigation, search

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

Description

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
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
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
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 Boolean 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
Goto recordnumber as Numeric Go to the specified record number
Item row as Numeric, column as Numeric [, value as Expression] Return the item text from the specified cell.
From v4.1 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 first 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).
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