Difference between revisions of "Grid"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 41: | Line 41: | ||
|Whether grid lines are displayed | |Whether grid lines are displayed | ||
|- | |- | ||
− | |AlternatingRowColors | + | |valign="top"|AlternatingRowColors |
− | |RW | + | |valign="top"|RW |
− | |Boolean | + | |valign="top"|Boolean |
− | |Whether rows have alternating background colors | + | |valign="top"|Whether rows have alternating background colors |
|- | |- | ||
|Readonly | |Readonly | ||
Line 56: | Line 56: | ||
|Whether text is word-wrapped | |Whether text is word-wrapped | ||
|- | |- | ||
− | |Scrollbars | + | |valign="top"|Scrollbars |
− | |RW | + | |valign="top"|RW |
− | |Numeric | + | |valign="top"|Numeric |
− | |Scrollbars displayed: 0 = none, 1 = horizontal, 2 = vertical | + | |valign="top"|Scrollbars displayed: 0 = none, 1 = horizontal, 2 = vertical |
|- | |- | ||
− | |RelativeRow | + | |valign="top"|RelativeRow |
− | |R | + | |valign="top"|R |
− | |Numeric | + | |valign="top"|Numeric |
− | |Currently selected row relative to the grid display | + | |valign="top"|Currently selected row relative to the grid display |
|- | |- | ||
− | |RelativeColumn | + | |valign="top"|RelativeColumn |
− | |R | + | |valign="top"|R |
− | |Numeric | + | |valign="top"|Numeric |
− | |Currently selected column relative to the grid display | + | |valign="top"|Currently selected column relative to the grid display |
|- | |- | ||
|HeaderHeight | |HeaderHeight | ||
Line 81: | Line 81: | ||
|Color of grid lines | |Color of grid lines | ||
|- | |- | ||
− | |RecordSource | + | |valign="top"|RecordSource |
− | |RW | + | |valign="top"|RW |
− | |Character | + | |valign="top"|Character |
− | |Source of data to which the grid is bound | + | |valign="top"|Source of data to which the grid is bound |
|- | |- | ||
− | |RecordSourceType | + | |valign="top"|RecordSourceType |
− | |RW | + | |valign="top"|RW |
− | |Numeric | + | |valign="top"|Numeric |
− | |Data source type: 0 = table, 1 = alias, 4 = SQL statement | + | |valign="top"|Data source type: 0 = table, 1 = alias, 4 = SQL statement |
|- | |- | ||
− | |RowSource | + | |valign="top"|RowSource |
− | |RW | + | |
− | |Character | + | |valign="top"|RW |
− | |Source of data to which the grid is bound | + | |valign="top"|Character |
+ | |valign="top"|Source of data to which the grid is bound | ||
|- | |- | ||
− | |RowSourceType | + | |valign="top"|RowSourceType |
− | |RW | + | |valign="top"|RW |
− | |Numeric | + | |valign="top"|Numeric |
− | |Data source type: 0 = table, 1 = alias, 4 = SQL statement | + | |valign="top"|Data source type: 0 = table, 1 = alias, 4 = SQL statement |
|- | |- | ||
− | |RecordMark | + | |valign="top"|RecordMark |
− | |RW | + | |valign="top"|RW |
− | |Numeric | + | |valign="top"|Numeric |
− | |Whether record number column is displayed: 0 (False), 1 (True) | + | |valign="top"|Whether record number column is displayed: 0 (False), 1 (True) |
|- | |- | ||
|valign="top"|RowColChange | |valign="top"|RowColChange |
Revision as of 10:51, 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 | ||
RemoveObject | ||
Columns | ||
Clear | ||
Autofit | ||
Doscroll | ||
Activatecell | ||
Additem | ||
Additems | ||
Sort | ||
Search |
Events
This class supports the Common events plus the following:
Event | Args | Description |
---|