Re: ADO DBASE Seek

From: Willi Kühnis (wkuehnis_at_bluewin.ch)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 07:48:49 +0100

Thanks for this Info,

years ago, I made it in clipper with Tables with something like this seek,
but I can't remember how.
This was very fast. But now everything is sovery slow.
Maybe they have good contracts with the hardware developers

Willi

"Paolo Mancini" <paolo.mancini@email.it> schrieb im Newsbeitrag
news:41a4b52f$1@newsgroups.borland.com...
> Ciao Willi,
> from the Delphi Help "NOTE: The VCL Seek method is a direct
implementation
> of the Seek method for the ADO Recordset object. At the time of this
> writing, this method is only supported for use with Microsoft Access2000
and
> the Jet 4 provider. "...
>
> Hope It Helps,
> Paolo Mancini
>
> "Willi Kühnis" <wkuehnis@bluewin.ch> ha scritto nel messaggio
> news:41a4820f$1@newsgroups.borland.com...
> > Hi,
> > I have a DBASE-Tables with .MDX-Index. (on the ID)
> > The table has about 120'000 records.
> > I want to use ADO (with ODBC-driver)
> >
> > What's the fastest way to search some values?
> >
> >
> > I think, with tADOTable and seek, but It never finds the correct record.
I
> > think, it don't set the Index .
> >
> > myADOTab:= TADOTable.Create(Application);
> > myADOTab.CursorLocation := clUseServer;
> > myADOTab.Connection := myConnection;
> > myADOTab.TableName := 'NAMEN';
> > myADOTab.indexName := 'ID';
> > myADOTab.Active := true;
> >
> >
> > what's wrong in this code?
> >
> >
> > Thanks a lot
> >
> >
>
>