🚀 go-pugleaf

Index is available only on server-side cursor. Do not add IndexDefs or
IndexFields, just set IndexName property.

//------------------------------------------
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:400e87ea$1@newsgroups.borland.com...
> 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
> > >
> > >
> >
> >
>
>