using Locate method with filtered dataset

ICE Systems

Delphi Developer

Fri, 23 Aug 2002 03:00:00 GMT

using Locate method with filtered dataset

When I use 'Locate' method on a dataset that is not filtered, correct record
is returned. However, if I apply some filter to the dataset, 'Locate'
returns incorrect record or raises exception 'Record not found'.
I use DAO with Access 2000 database.
Is there a workaround?

Other Threads

1. 'Locate' method with filtered dataset

2. Doing a Locate on a Filtered dataset.

3. Problems using DATASET.LOCATE

4. ADO DataSet's Locate is more Slower then Client DataSet

5. Dataset.Locate and Dataset.FindKey.

6. Using Locate method in Delphi 2

7. Problem using Locate method (w/multi-key fields)

8. Using the locate method with a TQuery

9. Bug in locate method (tquery, ttable) using integers!

10. Problem using Locate on filtered TCustomADODataSet