TEMP-TABLE-PREPARE( ) method

Signifies that all the field and index definitions for a temp-table have been supplied.

Return type:

LOGICAL

Applies to:

Temp-table object handle

 

Syntax 

TEMP-TABLE-PREPARE ( temp-table-name-exp )

temp-table-name-exp

A character expression that evaluates to a temp-table name to be used in subsequent query statements that refer to this temp-table.

The temp-table is in an UNPREPARED state after the first definitional method is called until this method is called. During this time, only ADD/CREATE type methods may be called.

The TEMP-TABLE-PREPARE( ) method must be called after all fields and indexes have been created and before any non-ADD/CREATE method can be called. This method causes the pending list of field and index definitions to become part of the actual temp-table object, which puts the temp-table in a PREPARED state (that is, makes it ready for use).

Note:

The NAME attribute of the Temp-table object handle is writeable for dynamic and AVM-generated temp-tables. A new temp-table name cannot be assigned until the TEMP-TABLE-PREPARE() method has been executed.