Show description

Recall, however, that adUseClient is the default CursorLocation property. Therefore, unless you changed the default setting, you do not have to make the explicit assignment. The procedure prints an excerpt of columns for the first five records in the currently sorted version of the recordset four different times. The first set of five records shows the default order, which is the order of the primary key or the order of entry for rows if no primary key exists. You donâ t need to set the Sort property to return records in this order (unless you are clearing a prior sort setting).

The Seek method makes available the recordset in the order of the index and positions the current record at the first record matching the criteria. You can refine the search behavior of the Seek method with some settings for its SeekOptions parameter using a member from the SeekEnum. The SeekÂ−Options setting appears immediately after the key value or values for a Seek method. Seek , . Table 1-4 lists the SeekEnum members with their values and behavior. Table 1-4. Intrinsic Constants for the SeekEnum Constant adSeekFirstEQ adSeekLastEQ 36 Value Behavior 1 Seek the first record on the index or indexes matching the key value or values.

Instead, the loop exits when the current time is n seconds or beyond the time just before entering the loop. A DateDiff function computes the difference between the loop start time and the current time within the loop in seconds. The procedure beeps to mark the end of the n-secondÂ− interval. Editing a Row The third sample in this section demonstrates how to update an existing field value in a recordset row with a new field value. The calling procedure, CallUpdateAFieldValue, calls four procedures in this sample.