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

Syntax

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.

GetIndexInfoByID( INPUT index-id AS INTEGER,
                  OUTPUT index-name AS CHARACTER,
                  OUTPUT proc-name AS CHARACTER )

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.

GetIndexInfoByID( INPUT index-id AS INTEGER,
                  OUTPUT index-name AS CHARACTER,
                  OUTPUT table-handle AS HANDLE,
                  OUTPUT proc-name AS CHARACTER )

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.