Board index » delphi » Using Index with SQL Query on Paradox Table

Using Index with SQL Query on Paradox Table

Hi,
Is there any way of using an index with a TQuery based on Paradox Table ? It
seems that all indexes created are ignored by the query.
RC
 

Re:Using Index with SQL Query on Paradox Table


There is a problem with the BDE using indexes on Paradox tables when you are
using queries that are doing multiple table joins.  If you use one table in the
query, the BDE will use the index just fine... as soon as you join multiple
tables the index stuff in the BDE dies.

Borland is aware of the problem, has been for a while, no fix in sight.  BTW the
QBE part of the BDE does the job of joining and using indexes just fine.

However, with all that said, if you simply want to see the data in a certain
order use the "order by" clause in the query.

-Gabe

Quote
Rgis CLUSEAU wrote:
> Hi,
> Is there any way of using an index with a TQuery based on Paradox Table ? It
> seems that all indexes created are ignored by the query.
> RC

Other Threads