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
setting an index to a table
Re: setting an index to a table
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
Re: setting an index to a table
IndexFieldNames does not use already created indexes in the table. I need a way to call already created indexes
Re: setting an index to a table
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.