ADO Find w/o MoveFirst

[MelissaEvans]

I need to be able to search a recordset for a specific piece of data. I use the .Find method with the skip of 0, moving forward, starting at the first record; but it doesn't find the record. If I do a .MoveFirst, then it does. The problem is that with SQL Server 7 and a server side cursor (required), it closes the reopens the recordset which takes forever! (testing on a 100,000 record table)

Any ideas why it can't find the record without the movefirst?

Thanks!
~Melissa

 

[dpaulson]

The Find method searches for a record in a Recordset that satisfies a specified criteria.

Note: A current row position must be set before calling this method.


This means that if your recordset is at the BOF or at EOF, you'll need to move to set the current row position. You can do a movelast and yor find will work.

David Paulson