Grid

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