TABLE Object
- Last UpdatedMar 28, 2023
- 2 minute read
The TABLE object is used to hold raw data in a manner that can be manipulated in a tabular manner, as a spreadsheet. Each row of the table represents a DBREF, and is defined by the primary key. The columns of the table contain information about the DBREF according to the associated COLUMN object.
Sorting of the table is by the order of the columns and the sort criteria on the relevant column. The formatting of the table data is via a REPORT object, which will allow the same data to be represented in many different ways.
Methods
|
Name |
Result |
Purpose |
|---|---|---|
|
Table() |
Constructor (initializes all the object settings). |
|
|
Table(DBREF ARRAY,COLUMN ARRAY) |
Constructor that passes the Primary Key as an ARRAY of DBREFS and the columns as an ARRAY of COLUMNS. |
|
|
Table(COLLECTION,COLUMNARRAY) |
Constructor that passes the Primary Key as a COLLECTION and the columns as an ARRAY of COLUMNS. |
|
|
PrimaryKey(COLLECTION) |
User defined Primary Key populated directly from a COLLECTION. |
|
|
PrimaryKey(ARRAY of DBREF) |
User defined Primary Key. |
|
|
Column(REAL n,COLUMN) |
Replaces the -nth column of the table. |
|
|
ClearColumns() |
Clears all the columns from the table. |
|
|
Columns(COLUMN ARRAY) |
Sets up the columns from an ARRAY of COLUMN objects. |
|
|
Evaluate() |
Evaluates the complete table. |
|
|
EvaluatePrimaryKey() |
Re-evaluates the Primary Key collection. |
|
|
PrimaryKey() |
DBREF ARRAY |
Returns the primary Key of the table, reference list for the columns of the table. |
|
Columns() |
COLUMN ARRAY |
Returns the column definitions. The order of the columns is important when sorting. |
|
Cell(REAL column,REAL row) |
ANY |
Returns the contents of the cell at the column and row. |
|
Column(REAL, n) |
ARRAY |
Returns the contents of nth column. |
|
Row(REAL, n) |
ARRAY |
Returns the contents of nth row. |
|
Cell(STRING key, DBREF) |
ANY |
Contents of the cell at the column and row. |
|
Column(STRING key) |
ARRAY |
Returns the contents of column identified by key. |
|
Row(DBREF) |
ARRAY |
Returns the contents of row identified by DBREF. |