Devart Forums

i have been using BDE now converted my data to firebird and using InterBase data access component in Delphi.
The problem is that in BDE i set index to table by calling table.indexname := 'indexname' in the interbase data access component i do not have indexname property, how can i use my created indexes??

thank you in advance

An analogue of the BDE component IndexName property in IBDAC is the IndexFieldNames property. See more detailed information about the method in IBDAC help: https://www.devart.com/ibdac/docs/?deva ... dnames.htm

IndexFieldNames does not use already created indexes in the table. I need a way to call already created indexes

In Firebird, server indexes are used on data sorting and search on the server-side automatically, e.g., on execution of WHERE, ORDER BY clauses. TIBCTable can't use server indexes. Therefore, when using local sorting or search (using methods IndexFieldNames, Locate, etc.), server indexes won't be used.