Re: TADOQuery and Access DB Indices

Article View: borland.public.cppbuilder.database.ado

Article #1838

Back to borland.public.cppbuilder.database.ado Previous Next

#1838

From: Viatcheslav V. Vassiliev
Date: Thu, 22 Jan 2004 13:26

28 lines
1868 bytes

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
>
>

Technical Details

Message-ID: <400fcfe1$2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <400eb1ef$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,9542d688c47386fc
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-01-22 05:40:08 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <400eb1ef$1@newsgroups.borland.com>
Subject: Re: TADOQuery and Access DB Indices
Date: Thu, 22 Jan 2004 16:26:33 +0300
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.234.218.42
Message-ID: <400fcfe1$2@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1074778081 213.234.218.42 (22 Jan 2004 05:28:01 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message