ADD-INDEX-FIELD( ) method

ADD-INDEX-FIELD( ) method

Adds the specified field to the specified index of a temp-table. It requires the named index to be added first.

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-INDEX-FIELD( index-name-exp , field-name-exp [ , mode-exp ] ) 
index-name-exp

A character expression that evaluates to the name of the index to which the field is being added.

field-name-exp

A character expression that evaluates to the name of the field to add to the index.

mode-exp

An expression that evaluates to desc if it is descending or asc if it is ascending. The default is asc.

The following example fragment adds to a temp-table a new unique primary index field with two components, the first ascending, the second descending:
tth:ADD-FIELDS-FROM("Customer", "SalesRep"). 
tth:ADD-NEW-INDEX("abidx", TRUE, TRUE). 
tth:ADD-INDEX-FIELD("abidx", "abfield1"). 
tth:ADD-INDEX-FIELD("abidx", "abfield2", "desc"). 
... 

Syntax
ADD-INDEX-FIELD( `index-name-exp` , `field-name-exp` [ , `mode-exp` ] )

tth:ADD-FIELDS-FROM("Customer", "SalesRep"). tth:ADD-NEW-INDEX("abidx", TRUE, TRUE). tth:ADD-INDEX-FIELD("abidx", "abfield1"). tth:ADD-INDEX-FIELD("abidx", "abfield2", "desc"). ...

OpenEdge Release 10.2B