Difference between revisions of "Column"
Yvonne.milne (Talk | contribs) (→Properties) |
Barrymavin (Talk | contribs) (→Properties) |
||
(One intermediate revision by the same user not shown) | |||
Line 37: | Line 37: | ||
|Character | |Character | ||
|Header caption text | |Header caption text | ||
+ | |- | ||
+ | |Celleditor | ||
+ | |RW | ||
+ | |Character | ||
+ | |VarChar CellEditor type. Text, Html, Stringlist. From 5.3. | ||
|- | |- | ||
|ChoiceList | |ChoiceList | ||
Line 67: | Line 72: | ||
|Character | |Character | ||
|Default value when adding new row | |Default value when adding new row | ||
+ | |- | ||
+ | |DynamicForeColor | ||
+ | |RW | ||
+ | |Character | ||
+ | |Dynamic Foreground color expression | ||
+ | |- | ||
+ | |DynamicBackColor | ||
+ | |RW | ||
+ | |Character | ||
+ | |Dynamic Background color expression | ||
|- | |- | ||
|ForeColor | |ForeColor | ||
Line 77: | Line 92: | ||
|Object | |Object | ||
|Return an object reference to the column's [[Header]] object | |Return an object reference to the column's [[Header]] object | ||
+ | |- | ||
+ | |Hyperlink | ||
+ | |RW | ||
+ | |Boolean | ||
+ | |Whether column is displayed as a hyperlink. From v5.3. | ||
|- | |- | ||
|InputMask | |InputMask | ||
Line 87: | Line 107: | ||
|Boolean | |Boolean | ||
|Whether column is read only | |Whether column is read only | ||
+ | |- | ||
+ | |Stringlist | ||
+ | |RW | ||
+ | |Character | ||
+ | |A comma separated list or a SQL SELECT From v5.3. | ||
+ | |- | ||
+ | |Total | ||
+ | |RW | ||
+ | |Boolean | ||
+ | |Whether column should be totalled. From v5.3. | ||
+ | |- | ||
+ | |Totalexpression | ||
+ | |RW | ||
+ | |Character | ||
+ | |The expression to total the column on. | ||
+ | |- | ||
+ | |Totalformat | ||
+ | |RW | ||
+ | |Character | ||
+ | |The mask for the total value displayed. | ||
|- | |- | ||
|Validation | |Validation |
Latest revision as of 00:48, 9 March 2020
Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.
Contents
Description
Shown below in a standalone Form. Click the image to see in a Custom Section in a Lianja Page.
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 |
---|---|---|---|
BackColor | RW | Numeric or Character | Background color |
Button | RW | Boolean | Whether column is displayed as a button. From v5.0. |
ButtonCaption | RW | Character | Caption text if column is displayed as a button. From v5.0. |
Caption | RW | Character | Header caption text |
Celleditor | RW | Character | VarChar CellEditor type. Text, Html, Stringlist. From 5.3. |
ChoiceList | RW | Character | List of choices for data input |
CustomDisplay | RW | Character | The name of a procedure/function that will return the display text for the cell. From v5.0. |
CustomEditor | RW | Character | The name of a procedure/function that will return a custom editor for the cell. This may be a container with multiple controls. From v5.0. |
DatamappingGet | RW | Character | Expression to evaluate for custom data mapping when reading data |
DatamappingSet | RW | Character | Expression to evaluate for custom data mapping when writing data |
Default | RW | Character | Default value when adding new row |
DynamicForeColor | RW | Character | Dynamic Foreground color expression |
DynamicBackColor | RW | Character | Dynamic Background color expression |
ForeColor | RW | Numeric or Character | Foreground color |
Header1 | R | Object | Return an object reference to the column's Header object |
Hyperlink | RW | Boolean | Whether column is displayed as a hyperlink. From v5.3. |
InputMask | RW | Character | Input mask for data entry |
Readonly | RW | Boolean | Whether column is read only |
Stringlist | RW | Character | A comma separated list or a SQL SELECT From v5.3. |
Total | RW | Boolean | Whether column should be totalled. From v5.3. |
Totalexpression | RW | Character | The expression to total the column on. |
Totalformat | RW | Character | The mask for the total value displayed. |
Validation | RW | Character | Validation condition to evaluate for update |
ValidationMessage | RW | Character | Message to display when Validation returns False |
Width | RW | Numeric | Width in pixels |
Methods
This class supports the Common Methods plus the following:
Method | Args | Description |
---|
Events
This class supports the Common Events plus the following:
Event | Args | Description |
---|