Seek/Find methods

[Kathy]

Hi ,

I have trouble using the "Find" method for ADO;
If Employees table has one-field Index : LastName, then this statement will
work fine :
strSearch = "LastName = 'ABC' "
DataEnvironment1.rsEmployee.Find strSearch

But if Employees table has mutiple-field index : LastName & FirstName,
then I am stuck:
strSearch = "LastName = 'ABC' , AND FirstName = 'DEF' "
DataEnvironment1.rsEmployee.Find strSearch

---> The error message I've got is:
"The application is using arguments that are of the wrong type ,
are out of acceptable range or are in conflict with one another"

Please help me out.
Thanks

You could have that error in case if your record contains single quote, for example Last Name is "O'Bryan".
Vlad

[Kathy]

Not really, My data does not have any quotes.
I even tried to "find" on Fields of number format (EmployeeID....),
but still

[Lothar Haensler]

read MSDN article Q195222.
it states that ADO find method only supports one criteria!
it also gives you a few workarounds like using Filters.