🚀 go-pugleaf

With indeces you should use Seek() method. This requires 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:400e1da8$1@newsgroups.borland.com...
> I've encountered a problem with ADO and Access:
>
> My access database has five tables, each table as multiple indices.
>
> I'm using a TADOConnection and a TADOTable to access the MS Access DB;
code
> below used to setup the objects:
>
> #define CONNECT_STRING_FMT     "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=%s;User Id=admin;Password="
>
>             // Create a DB Connection COM Object Instance
>             mpConnection = new TADOConnection(NULL);
>             mpConnection->ConnectOptions = coConnectUnspecified;
>             mpConnection->CursorLocation = clUseClient;
>             mpConnection->IsolationLevel = ilCursorStability;
>             mpConnection->LoginPrompt = false;
>             mpConnection->Mode = cmShareDenyNone;
>             strConnectionString = Format(CONNECT_STRING_FMT,
> OPENARRAY(TVarRec, (strMediaLibraryDBPath)));
>             mpConnection->ConnectionString = strConnectionString;
>             mpConnection->Connected = true;
>
>             // Create a Table Object Instance for the Container Table
>             mpContainerTable = new TADOTable(NULL);
>             mpContainerTable->Active = false;
>             mpContainerTable->Connection = mpConnection;
>             mpContainerTable->CursorType = ctKeyset;
>             mpContainerTable->TableName  = TABLE_NAME_CONTAINER;
>             mpContainerTable->IndexName  = INDEX_NAME_PRIMARY;
>             mpContainerTable->Active = true;
>
>             {  ... repeat for each addition table...  }
>
> I intend on doing all of the normal database management stuff:  a)  add,
> modify and delete records, b) search tables using various indices, c)
> transaction bracketing, etc.  What method is recommended for doing
> index-based search using a relational operator?
>
> example:  get record whose parentID >= 10
>
> In DAO, the recordset.seek() allows a relational operator on one or more
key
> values against the current index.  Is there an equivalent?
>
> Thanks in advance for your help.
>
> Regards;
>
> Al Dube
>
>