ADD-FIELDS-FROM( ) method

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.

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

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"). . . .

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

OpenEdge Release 10.2B