Page 276 - DCAP408_WEB_PROGRAMMING

Web Programming

Notes Self Assessment

Fill in the blanks:
1. The set of fields associated with a recordset (and with each individual record) is accessible
through the ............................ and Field object.

2. You use ............................ objects to manipulate data from a provider.
3. ............................ provides a static copy of a set of records for you to use to find data or
generate reports.

4. Set the CursorType property prior to opening the Recordset to choose the cursor type, or
pass a CursorType argument with the ............................
5. If a ............................ does not support the requested cursor type, it may return another
cursor type.
6. Sets or returns a Long value that can be set to one of the ............................ values.
7. To verify specific functionality of the returned cursor, use the ............................ method.

12.2 Filter Property

Indicates a filter for data in a Recordset.

12.2.1 Settings and Return Values

Sets or returns a Variant value, which can contain one of the following:
 Criteria string — a string made up of one or more individual clauses concatenated with
AND or OR operators.

 Array of bookmarks — an array of unique bookmark values that point to records in the
Recordset object.
 A FilterGroupEnum value.

Remarks

Use the Filter property to selectively screen out records in a Recordset object. The filtered
Recordset becomes the current cursor. Other properties that return values based on the current
cursor are affected, such as AbsolutePosition, AbsolutePage, RecordCount, and PageCount. This
is because setting the Filter property to a specific value will move the current record to the first
record that satisfies the new value.
The criteria string is made up of clauses in the form FieldName-Operator-Value (for example,
“LastName = ‘Smith’”). You can create compound clauses by concatenating individual clauses
with AND (for example, “LastName = ‘Smith’ AND FirstName = ‘John’”) or OR (for example,
“LastName = ‘Smith’ OR LastName = ‘Jones’”). Use the following guidelines for criteria strings:

 FieldName must be a valid field name from the Recordset. If the field name contains
spaces, you must enclose the name in square brackets.
 Operator must be one of the following: <, >, <=, >=, <>, =, or LIKE.

 Value is the value with which you will compare the field values (for example, ‘Smith’, #8/
24/95#, 12.345, or $50.00). Use single quotes with strings and pound signs (#) with dates.

270 LOVELY PROFESSIONAL UNIVERSITY