Re: ADO DBASE Seek

From: Paolo Mancini (paolo.mancini_at_email.it)
Date: 11/24/04


Date: Wed, 24 Nov 2004 17:21:21 +0100

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
>
>



Relevant Pages

  • Recordset not updatable
    ... I found a help file that shows an ado recordset object being applied to a forms recordset. ... Set cmd = New ADODB.Command ...
    (microsoft.public.access.formscoding)
  • Re: Number of columns in an ADO recordset
    ... I access first column of an ADO recordset object by calling rs, ... Dim fld as ADODB.Field ...
    (comp.lang.basic.visual.misc)
  • Re: BatchUpdate with ADO
    ... Look at the UpdateBatch method of the ADO recordset object. ... MVP Microsoft Access ...
    (microsoft.public.vb.database.ado)
  • oracle outer join
    ... I use ADO and set the provider is 'OraOLEDB.Oracle.1'; ... when I use outer join to get ado recordset object, The recordset can't editable, ...
    (microsoft.public.data.ado)