🚀 go-pugleaf

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