Subject Delphi TIBQuery.Locate
Author julien_ferraro
Hello,

I've got a table Article and an index on the field CODE_BARRES of
this table

when I do

QArticle.Locate('CODE_BARRES', ECodeBare.Text, []);

the answer is very long (nearly one minute, and there's only 3000
records in the table);

With an Microsoft Access database everything works fine. And in the
Delphi help I can read that the Locate function uses the fastest way
to find a record.

I created my index using
create index I_CODEBARRES on Article(CODE_BARRES)

Did I do something wrong ? Or do I have to specify (how ?) the index
I want to use for my search?

In advance Thank You

Julien