Software Customisation
Reference Manual
Summary of Objects, Members and Methods
:
Object Type Details
: TABLE Object
TABLE Object
The TABLE object is used to hold raw data in a manner that can be manipulated in a tabular manner, i.e. 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 (initialises 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.
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.