Filtering Records Using the Filter Property

You can use the ADO Filter property to obtain a set of records that meet specific criteria. To remove the filter, set the Filter property to adFilterNone.

Use the Filter property as a workaround to the ADO Find method whenever you need to find records that meet more than one condition. If the specific set of records you want to obtain is located on the SQL Server, you should use stored procedures instead of the Filter property.

The FltrRecords procedure in Hands-On 14-10 creates a filtered view of customers listed in the Northwind database who are located in Madrid, Spain.

0 0

Post a comment