GetIndexInfoByID( ) method

Returns information about a temp-table index when the ID is specified. The ID is a numeric value that identifies the index. If the ID is valid for an existing temp-table index, this returns TRUE. Otherwise, it returns FALSE. This property is read-only.

Return type:

LOGICAL

Access:

PUBLIC STATIC

Applies to:

Progress.Database.TempTableInfo class

This method supports two overloaded versions. The first version returns the index name and name of the procedure or class that instantiated the temp-table.

 

Syntax 

GetIndexInfoByID(INPUT index-id, OUTPUT index-name, OUTPUT proc-name

The second version returns the index-name, the handle to the temp-table for that index, and the name of the procedure or class that instantiated the temp-table.

 

Syntax 

GetIndexInfoByID(INPUT index-id, OUTPUT index-name, OUTPUT table-handle, OUTPUT proc-name

index-id

An integer expression which evaluates the ID of the temp-table index.

index-name

Returns the name of the index specified by the index ID. The format is tablename.indexname. For example: ttCustomer.custnum.

table-handle

Returns a HANDLE to the temp-table specified by the index ID.

proc-name

Returns the name of the procedure or class where the temp-table was created. For a static temp-table, the procedure is used with the DEFINE TEMP-TABLE statement. For a dynamic temp-table, it is the procedure that executes the TEMP-TABLE-PREPARE() method. The name of the procedure is the name that is specified when you run mydir/test.p.