Re: ADO DBASE Seek

Peter
Date: 11/26/04 

Date: Fri, 26 Nov 2004 08:14:51 +0100

Hi Willi,

depending on the ODBC-driver you use, you can explicitly activate
the index file. This might speed up the select statement, but
only if your where-clause exactly matches the index.

It is highly recommended not to use dBase files with ADO. Even
the JET engine (Access) will work much better.

Next problem with most ODBC-drivers is the destruction of index
files while writing data to your database.

Additionally record locking will not work between programms with
ODBC and others with native access.

After years of working with dBase and Clipper / Visual Objects I
switched to Delphi and Access / MySQL / MSDE, ... Much better
now.

Peter

"Willi Kühnis" <wkuehnis@bluewin.ch> schrieb im Newsbeitrag
news:41a57f49@newsgroups.borland.com...
Thanks,

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

Willi