How do I find a single record or multiple records with ADO 1

[bmj]

I am using an ADO control linked to a Data Link File. What is some correct code I can use to search for a string in a certain field in the database? Can I use the same code for finding multiple records if they exist?

 

[culshaja]

I think there are find and findnext methods associated with the associated recordset. There is also a filter method associted with either the control or definitely with the associated recordset which can be got at via the ADO DataControls properties.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305