Re: Finding a record in a TADOTable

The seek method uses the index if the table is live.

Otherwise you are actually looking at a snapshot of the data. Therefore you
do not have access to the index directly.
I use locate quite often and seems to work well enough on reasonable size
result sets.

"Edward Diener" <eddielee_no_spam_here@xxxxxxxxxxxxxx> wrote in message
news:42934948$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> I would like to be able to find a record in a TADOTable based on an
> index. The only thing I have found in this regard is the Seek method but
> this appears to require a number of other properties to be set and is
> supposedly supported only with a few RDBMSs. The other possibility is
> the Locate/Lookup set. Is there really no way to use the indices of a
> TADOTable to find a record ? It would seem natural that any table would
> allow one to use an index to quickly find a record in the table, else
> what purpose do indices serve.


.