ADD-FIELDS-FROM( ) method

Copies the field definitions from the specified source table to a temp-table. It is intended for use when a temp-table represents a join. If it finds fields that are already in the temp-table, it ignores them.

This method cannot be called after TEMP-TABLE-PREPARE( ) has been called unless CLEAR( ) is called first.

Return type:

LOGICAL

Applies to:

Temp-table object handle

 

Syntax 

ADD-FIELDS-FROM ( { source-buffer-handle-exp | source-table-name-exp }   [ , except-list-exp ] )

source-buffer-handle-exp

An expression that evaluates to a buffer handle from which to copy the field definitions.

source-table-name-exp

An expression that evaluates to a table name from which to copy the field definitions.

except-list-exp

A character expression that evaluates to a comma-separated list of field names to be excluded from the new table definition.

The following example fragment creates a join temp-table from the Customer and Order tables:

 

DEFINE VARIABLE tth AS HANDLE NO-UNDO.   CREATE TEMP-TABLE tth. tth:ADD-FIELDS-FROM("Customer"). tth:ADD-FIELDS-FROM("Order"). tth:TEMP-TABLE-PREPARE("cust-ord"). . . .

The following fragment creates a temp-table from the Customer table except for the SalesRep field:

 

tth:ADD-FIELDS-FROM("Customer", "SalesRep").

Note:

There is a limit to the number of fields that can be accommodated in a temp-table object. The limit depends on how large the field information (initial value, validate information, help messages, etc.) is, but you should plan on a limit of approximately 1000 fields.

This method does not create any indexes. Either indexes must be added specifically through one of the ADD-INDEX methods, or a default index is created.