🚀 go-pugleaf

Thanks for the info.

When opening the TADOTable object after having set the
Connection->CursorLocation = clUseServer, an EDatabaseError is generated
stating "A component named 'ContainerByParent' already exists."  The
'ContainerByParent' component is an index within the just opened table.  If
I use the clUseClient CursorLocation option, the Table Open succeeds, but
Seeks fail.

Any thoughts?

Regards;

Al Dube


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:400e20a7$1@newsgroups.borland.com...
> 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
> >
> >
>
>