ADO DBASE Seek

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

Date: Wed, 24 Nov 2004 13:46:05 +0100

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