Difference between revisions of "Grid"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 51: | Line 51: | ||
|Whether grid is readonly | |Whether grid is readonly | ||
|- | |- | ||
− | | | + | |WordWrap |
|RW | |RW | ||
|Boolean | |Boolean | ||
Line 148: | Line 148: | ||
!width="50%"|Description | !width="50%"|Description | ||
|- | |- | ||
− | |AddColumn | + | |valign="top"|AddColumn |
− | |column as Numeric | + | |valign="top"|column as Numeric |
− | |Add a column at the specified column position | + | |valign="top"|Add a column at the specified column position |
|- | |- | ||
− | |RemoveColumn | + | |valign="top"|RemoveColumn |
− | |column as Numeric | + | |valign="top"|column as Numeric |
− | |Remove a column at the specified column position | + | |valign="top"|Remove a column at the specified column position |
|- | |- | ||
− | |AddObject | + | |valign="top"|AddObject |
− | | | + | |valign="top"|existing as Object | newobject as Character, class as Character |
− | | | + | |valign="top"|Add an existing object or a new object, in which case the object's class must also be specified and optionally its caption |
|- | |- | ||
− | |RemoveObject | + | |valign="top"|RemoveObject |
− | | | + | |valign="top"|existing as Object |
− | | | + | |valign="top"|Remove the specified object |
|- | |- | ||
− | |Columns | + | |valign="top"|Columns |
− | | | + | |valign="top"|column as Numeric |
− | | | + | |valign="top"|Return an object reference to the specified column |
|- | |- | ||
− | |Clear | + | |valign="top"|Clear |
− | | | + | |valign="top"|None |
− | | | + | |valign="top"|Clear the grid |
|- | |- | ||
− | |Autofit | + | |valign="top"|Autofit |
− | | | + | |valign="top"|None |
− | | | + | |valign="top"|Resize the columns to fit the grid |
|- | |- | ||
− | | | + | |valign="top"|DoScroll |
− | | | + | |valign="top"|scroll as Numeric |
− | | | + | |valign="top"|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 |
|- | |- | ||
− | | | + | |valign="top"|ActivateCell |
− | | | + | |valign="top"|row as Numeric, column as Numeric |
− | | | + | |valign="top"|Select the cell at the specified row and column position |
|- | |- | ||
− | | | + | |valign="top"|AddItem |
− | | | + | |valign="top"|data as Character |
− | | | + | |valign="top"|Add an item |
|- | |- | ||
− | | | + | |valign="top"|AddItems |
− | | | + | |valign="top"|selectstatement as Character | commalist as Character | pipelist as Character | items as Array [,headers as Array[, headerwidths as Array]] |
− | | | + | |valign="top"|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 |
|- | |- | ||
− | |Sort | + | |valign="top"|Sort |
− | | | + | |valign="top"| |
− | | | + | |valign="top"| |
|- | |- | ||
− | |Search | + | |valign="top"|Search |
− | | | + | |valign="top"| |
− | | | + | |valign="top"| |
|- | |- | ||
|} | |} |
Revision as of 11:15, 3 January 2013
Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.
Properties
This class supports the Common properties plus the following:
Property | Access (R/RW) | Value | Description |
---|---|---|---|
RowCount | RW | Numeric | Number of rows |
RowHeight | RW | Numeric | Row height in pixels |
ActiveRow | RW | Numeric | Currently selected row |
ActiveColumn | RW | Numeric | Currently selected column |
ColumnCount | RW | Numeric | Number of columns |
GridLines | RW | Boolean | Whether grid lines are displayed |
AlternatingRowColors | RW | Boolean | Whether rows have alternating background colors |
Readonly | RW | Boolean | Whether grid is readonly |
WordWrap | RW | Boolean | Whether text is word-wrapped |
Scrollbars | RW | Numeric | Scrollbars displayed: 0 = none, 1 = horizontal, 2 = vertical |
RelativeRow | R | Numeric | Currently selected row relative to the grid display |
RelativeColumn | R | Numeric | Currently selected column relative to the grid display |
HeaderHeight | RW | Numeric | Column header height in pixels |
GridLineColor | RW | Numeric | Color of grid lines |
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 |
RowSource | RW | Character | Source of data to which the grid is bound |
RowSourceType | RW | Numeric | Data source type: 0 = table, 1 = alias, 4 = SQL statement |
RecordMark | RW | Numeric | Whether record number column is displayed: 0 (False), 1 (True) |
RowColChange | RW | Numeric | Type of cell movement made: 0 = no change, 1 = row change, 2 = column change, 3 = row and column change |
ViewMode | RW | Boolean | View mode for split grids: 0 = grid view, 1 = form view, 2 = split view |
Relatedform | RW | ||
Picture | RW | Character | Filename of background image |
Recno | R | Numeric | Current record number |
Rowid | R | Numeric | Current record number |
Methods
This class supports the Common methods plus the following:
Method | Args | Description |
---|---|---|
AddColumn | column as Numeric | Add a column at the specified column position |
RemoveColumn | column as Numeric | Remove a column at the specified column position |
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 |
RemoveObject | existing as Object | Remove the specified object |
Columns | column as Numeric | Return an object reference to the specified column |
Clear | None | Clear the grid |
Autofit | None | Resize the columns to fit the grid |
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 |
ActivateCell | row as Numeric, column as Numeric | Select the cell at the specified row and 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 |
Sort | ||
Search |
Events
This class supports the Common events plus the following:
Event | Args | Description |
---|