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
Syntax
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.