INDEX-INFORMATION( ) method

Returns index information in a comma-separated list for the i^th index in the buffer’s table.

The returned comma-separated list consists of the following in the specified order:

The index name
Three integer values of value 0 (FALSE) or 1 (TRUE) depending on whether the index is unique, primary or a word index
The names of the index fields, each followed by a 0 (ascending) or 1 (descending)

Return type: CHARACTER

Applies to: Buffer object handle

Syntax

INDEX-INFORMATION(i)

i

The relative number of the buffer table’s index for which you want information.
When the index argument, i, is beyond the number of indices in the table or is otherwise invalid, the Unknown value (?) is returned.

The following code fragment requests information about the third index in the customer table:

buffCustHdl = BUFFER Customer:HANDLE. IndexVar = buffCustHdl:INDEX-INFORMATION(3).

The returned string would look like: “CustNum,1,1,0,CustNum,0" which means that the third index in the Customer table is called “CustNum”. It is unique and primary, and is not a word index and it consists of one ascending component, CustNum.

OpenEdge Release 10.2B

Copyright © 2009 Progress Software Corporation