Difference between revisions of "Column"
Yvonne.milne (Talk | contribs) |
Barrymavin (Talk | contribs) (→Properties) |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
====Description==== | ====Description==== | ||
− | [[ | + | Shown below in a standalone [[Form]]. Click the image to see in a [[Custom_Sections_and_Gadgets|Custom Section]] in a Lianja [[Page Attributes|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. | + | [[{{ns:file}}:grid_column.png|link={{filepath:grid_column_header_cs.png}}|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==== | ====Properties==== | ||
Line 20: | Line 22: | ||
|Numeric or Character | |Numeric or Character | ||
|Background color | |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 | |Caption | ||
Line 25: | 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 30: | Line 47: | ||
|Character | |Character | ||
|List of choices for data input | |List of choices for data input | ||
+ | |- | ||
+ | |valign="top"|CustomDisplay | ||
+ | |valign="top"|RW | ||
+ | |valign="top"|Character | ||
+ | |The name of a procedure/function that will return the display text for the cell.<br>From v5.0. | ||
+ | |- | ||
+ | |valign="top"|CustomEditor | ||
+ | |valign="top"|RW | ||
+ | |valign="top"|Character | ||
+ | |The name of a procedure/function that will return a custom editor for the cell.<br>This may be a container with multiple controls. From v5.0. | ||
|- | |- | ||
|DatamappingGet | |DatamappingGet | ||
Line 45: | 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 55: | 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 65: | 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 |
---|