Subject Re: [IBO] GetIndexNames
Author Lucas Franzen
"Gerard J.M.Houtenbos" schrieb:
>
> I'm converting an Interbase Delphi 4-application from the BDE to
> IBO.
> Somewhere I need a list of the indexes on a Table.
> I used to use TTable.GetIndexrNames for that purpose, but
> TIBOTable.GetIndexNames is not supported.
>
> Any solutions?

SELECT RDB$INDEX_NAME
FROM RDB$INDICES
WHERE RDB$RELATION_NAME = <YOUR_TABLENAME>
(ADD: "AND RDB$INDEX_NAME NOT STARTING WITH 'RDB$' if you're only
interested in your own created indices; assuming you don't name them
RDB$xxx)

You can also get ALL indices from the
TIBConnection.SchemaCache.IndexNames.

But this (TIB_StringList) has got the format: INDEXNAME,RELATIONNAME


Luc.