Devart Forums

Posted: **Sun 17 Jun 2007 04:09**

I am reasonably new to IBDAC and am currently converting one BDS2006 project from IBX to IBDAC

One problem I have hit quite early on is Index Management.

With IBX I can use the three lines

1) aTable.IndexDefs.Update;
2) aTable.GetInsexNames{aStringList);
3) with aTable.INdexDefs.AddIndexDef
- Name := 'SOME_INDEX_NAME');
  Fields := 'FIELD_ONE;FIELD_FOUR;FIELD_NINE';
  Options = [ixUnique, ixDescending];
end;

What are the equivalent statements for IBDAC?

regards and thanks

SeaCay

Posted: **Mon 18 Jun 2007 15:27**

The TIBCTable component provides limited compatibility with BDE and IBX table components.
The limitations include not supporting any table structure modification including Table creation, Index modification and other.
We will consider adding possibility of reading IndexDefs from server in one of the next IBDAC builds.
Now you should use special SQL query to obtain such information. For example:

Code: Select all

    Select I.RDB$INDEX_NAME, I.RDB$UNIQUE_FLAG,
    I.RDB$INDEX_TYPE, I.RDB$SEGMENT_COUNT, S.RDB$FIELD_NAME from RDB$INDICES I,
    RDB$INDEX_SEGMENTS S where I.RDB$INDEX_NAME = S.RDB$INDEX_NAME
    and I.RDB$RELATION_NAME = 'THE_NAME_OF_THE_TABLE'

where THE_NAME_OF_THE_TABLE is your table name. You can run this query with TIBCQuery, and
analyze retrieved data.

Posted: **Mon 18 Jun 2007 22:34**

Thanks for the reply, I will follow your advice.

Devart Forums

Converting From IBX - Index Management

Converting From IBX - Index Management