Filtering Records with an SQL Clause

You can restrict the records returned in an open recordset to those matching the criteria specified in the SQL WHERE clause. If the expression contained in the WHERE clause is True, then the record is selected; otherwise, the record is excluded from the opened set of records.

The procedure in Hands-On 14-9 opens a recordset that contains only records having the value of Null in the Region field or an entry of "Mrs." in the TitleOfCourtesy field.

Creating and Manipulating Databases with ADO

0 0

Post a comment