🚀 go-pugleaf

Hi Vassiliev;

Thanks for the info.  Do you have any idea what the performance
characteristics are for searching an Access database using TADOTable->Seek
vs. TADOQuery with SQL statements?

Thanks again.

Regards;

Al Dube


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:400fcfe1$2@newsgroups.borland.com...
> TADOQuery can not use indeces. Use TADOTable with CursorLocation =
> clUseServer and TableDirect = true.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Alain M. Dube" <adube@cadencesoftware.com> �������/�������� � ��������
> ���������: news:400eb1ef$1@newsgroups.borland.com...
> > Hello;
> >
> > How do queries via SQL statements in a TADOQuery object make use of a
> target
> > MS Access Database's indices?  Do the fields named in a SELECT statement
> > drive the use of anparticular index?  Is there a direct way to specify
> which
> > index to use in a query?
> >
> > Thanks in advance for the help.
> >
> > Regards;
> >
> > Al Dube
> >
> >
>
>