Subject | Delphi TIBQuery.Locate |
---|---|
Author | julien_ferraro |
Post date | 2002-08-22T07:06:22Z |
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
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