Progress
Language Reference


ADD-INDEX-FIELD( ) Method

This method adds the specified field to the specified index. 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","sales-rep").
tth:ADD-NEW-INDEX("abidx",true,true).
tth:ADD-INDEX-FIELD("abidx","abfield1").
tth:ADD-INDEX-FIELD("abidx","abfield2","desc").
... 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095