🚀 go-pugleaf

Thanks Pat for the info.  I tried it and it works fine.  Can you shed some
light as to how/if the SQL statement "WHERE" clause employs a table's
indices to retrieve the desired data most efficiently?  Does the
TADOQuery->IndexName influence index usage for a query?

Thanks again.

Regards;

Al Dube


"Pat" <pat-rizioAGR@libero.it> wrote in message
news:400e5c27@newsgroups.borland.com...
> Hi Al,
> I think you can use also a TADOQuery component just as follow:
>
> TADOQuery->Close();
> TADOQuery->SQL->Clear();
> TADOQuery->SQL->Add("SELECT * FROM " + TableName + " WHERE parentID >=
10");
> TADOQuery->Open();
>
> Regards,
> Pat
>
>
>
> Alain M. Dube wrote:
>
> > 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
> >
> >
>
>
> -- 
> remove AGR for reply
>