Re: ADO DBASE Seek

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

  • Next message: Willi Kühnis: "Re: ADO DBASE Seek" 
    Date: Thu, 25 Nov 2004 07:46:31 +0100

    Thanks,

    this way, it works,
    but it's very slow

    Willi

    "Brian Bushay TeamB" <BBushay@Nmpls.com> schrieb im Newsbeitrag
    news:f4eaq09ldvivl7vgqc32dsl65ebnqdqdck@4ax.com...
    >
    > >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?
    >
    > Probably using a select query
    > Select * from your table
    > where Somefield = 'Search criteria'
    > >
    > >
    > >I think, with tADOTable and seek, but It never finds the correct record.
    I
    > >think, it don't set the Index .
    > Seek only works with Access databases and even then it is limited as to
    when it
    > can be used
    > --
    > Brian Bushay (TeamB)
    > Bbushay@NMPLS.com

  • Next message: Willi Kühnis: "Re: ADO DBASE Seek"

    Relevant Pages

    • Re: cancel during asyncfetchnonblocking
      ... >The problem with this seems to be, that the query is not really cancelled ... >AdoDS.Close - looking at my memory usage it climbs incredibly. ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: How to record quotation marks
      ... query1.sql.add('insert into memorando (chamada, texto) values ... or use parameters in your query ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: About lookup fields..
      ... No you will have to use a TadoDataset and then create the field in your query to ... sort by it. ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: cancel during asyncfetchnonblocking
      ... >Can you use the same object for another query? ... >settings but can't seem to get this working in an OK ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: Simple TADOQuery is not live
      ... Brian Bushay TeamB wrote: ... >> The query is left open because its just had lots of validation done ... row I do a kind of two stage commit by first querying my date/time with ...
      (borland.public.delphi.database.ado)
    • Quantcast