🚀 go-pugleaf

Thanks Viatcheslav;

You've been very helpful.

Regards;

Al Dube


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:400ffff4@newsgroups.borland.com...
> If you need to do the search once, use SQL, if you need to do multiple
> searches in one table, use Seek. BTW, indeces are supported for MS Jet but
> usually OLEDB providers do not support indeces. For example, OLEDB
provider
> for MS SQL Server does not support them.
>
> //------------------------------------------
> 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:400fda69$1@newsgroups.borland.com...
> > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>