Table Operation Methods

Prefix the following methods with the <TBL> pointer. Use the TABLE.OPEN(), TABLE.CREATE_END(), and <OBJECT>.TABLE_GET() methods to return the <TBL> pointer.

Function

 

Description

.APPEND()

V5

Appends the records of <TBL> to another table.

.COPY()

V5

Copies all or some of the fields from <TBL> or set to a new table.

.CROSSTAB()

V5

Cross-tabulates the records of a table or set, creating a new table.

.EXPORT()

V5

Exports the records of a table or set to a file of a different format.

.IMPORT()

V5

Import the records of a file of a different format into a new table file.

.INTERSECT()

V5

Creates a new table by merging the records from <TBL> with matching records from a Secondary table. The new table contains only those records from <TBL> that have a matching record in the Secondary table

.JOIN()

V5

Create a new table by merging the records from <TBL> with matching records from a Secondary table. The new table contains every record from <TBL>, whether or not a matching record is found in the Secondary table.

.POST()

V5

Replaces, adds, or subtracts field values in <TBL> using field values from a Transaction table.

.SUBTRACT()

V5

Creates a new table by merging the records from <TBL> with records from a Secondary table. The new table contains one record for each record in <TBL> that has no matching record in the Secondary table.

.SUMMARIZE()

V5

Summarizes the records of <TBL>, creating a new table to store the result.

.UPDATE()

V5

Updates the records of <TBL>.

See Also

Operation Functions and Methods