ado_ref_recordset.asp

W3Schools tutorial..web designing

    <td valign="top"><a href="prop_rs_bofeof.asp">EOF</a></td>
    <td valign="top">Returns true if the current record position is after the last record, otherwise false</td>
  </tr>
  <tr>
    <td valign="top"><a href="prop_rs_filter.asp">Filter</a></td>
    <td valign="top">Sets or returns a filter for the data in a Recordset object</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_index.asp">Index</a></td>
    <td valign="top">Sets or returns the name of the current index for a
      Recordset object</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_locktype.asp">LockType</a></td>
    <td valign="top">Sets or returns a value that specifies the type of locking
      when editing a record in a Recordset</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_marshaloptions.asp">MarshalOptions</a></td>
    <td valign="top">Sets or returns a value that specifies which records are to 
	be returned to the server</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_maxrecords.asp">MaxRecords</a></td>
    <td valign="top">Sets or returns the maximum number of records to return to a Recordset object from a query</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_pagecount.asp">PageCount</a></td>
    <td valign="top">Returns the number of pages with data in a Recordset object</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_pagesize.asp">PageSize</a></td>
    <td valign="top">Sets or returns the maximum number of records allowed on a
      single page of a Recordset object</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_recordcount.asp">RecordCount</a></td>
    <td valign="top">Returns the number of records in a Recordset object</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_sort.asp">Sort</a></td>
    <td valign="top">Sets or returns the field names in the Recordset to sort on</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_source.asp">Source</a></td>
    <td valign="top">Sets a string value or a Command object reference, or
      returns a String value that indicates the data source of the Recordset
      object</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_state.asp">State</a></td>
    <td valign="top">Returns a value that describes if the Recordset object is
      open, closed, connecting, executing or retrieving data</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_status.asp">Status</a></td>
    <td valign="top">Returns the status of the current record with regard to
      batch updates or other bulk operations</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="prop_rs_stayinsync.asp">StayInSync</a></td>
    <td valign="top">Sets or returns whether the reference to the child records
      will change when the parent record position changes</td>
  </tr>
</table>

<h3>Methods</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
  <tr valign="top">
    <th width="35%" align="left" valign="top" height="19">Method</th>
    <th width="65%" align="left" valign="top" height="19">Description</th>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_addnew.asp">AddNew</a></td>
    <td valign="top" height="19">Creates a new record</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_cancel.asp">Cancel</a></td>
    <td valign="top" height="19">Cancels an execution</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_cancelbatch.asp">CancelBatch</a></td>
    <td valign="top" height="19">Cancels a batch update</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_cancelupdate.asp">CancelUpdate</a></td>
    <td valign="top" height="19"><p>Cancels changes made to a record of a Recordset
      object
</p>

    </td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_clone.asp">Clone</a></td>
    <td valign="top" height="19">Creates a duplicate of an existing Recordset</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_close.asp">Close</a></td>
    <td valign="top" height="19">Closes a Recordset</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_comparebookmarks.asp">CompareBookmarks</a></td>
    <td valign="top" height="19">Compares two bookmarks</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_delete.asp">Delete</a></td>
    <td valign="top" height="19">Deletes a record or a group of records</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_find.asp">Find</a></td>
    <td valign="top" height="19">Searches for a record in a Recordset that
      satisfies a specified criteria</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_getrows.asp">GetRows</a></td>
    <td valign="top" height="19">Copies multiple records from a Recordset object
      into a two-dimensional array</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_getstring.asp">GetString</a></td>
    <td valign="top" height="19">Returns a Recordset as a string</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_move.asp">Move</a></td>
    <td valign="top" height="19">Moves the record pointer in a Recordset object</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_movefirst.asp">MoveFirst</a></td>
    <td valign="top" height="19">Moves the record pointer to the first record</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_movefirst.asp">MoveLast</a></td>
    <td valign="top" height="19">Moves the record pointer to the last record</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_movefirst.asp">MoveNext</a></td>
    <td valign="top" height="19">Moves the record pointer to the next record</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_movefirst.asp">MovePrevious</a></td>
    <td valign="top" height="19">Moves the record pointer to the previous record</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_nextrecordset.asp">NextRecordset</a></td>
    <td valign="top" height="19">Clears the current Recordset object and returns
      the next Recordset object by looping through a series of commands</td>
  </tr>
  <tr>
    <td valign="top" height="19"> <a href="met_rs_open.asp">Open</a></td>
    <td valign="top" height="19">Opens a database element that gives you access
      to records in a table, the results of a query, or to a saved Recordset</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_requery.asp">Requery</a></td>
    <td valign="top" height="19">Updates the data in a Recordset by re-executing
      the query that made the original Recordset</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_resync.asp">Resync</a></td>
    <td valign="top" height="19">Refreshes the data in the current Recordset from the original database</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_save.asp">Save</a></td>
    <td valign="top" height="19">Saves a Recordset object to a file or a Stream
      object</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_seek.asp">Seek</a></td>
    <td valign="top" height="19">Searches the index of a Recordset to find a
      record that matches the specified values</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_supports.asp">Supports</a></td>
    <td valign="top" height="19">Returns a boolean value that defines whether or
      not a Recordset object supports a specific type of functionality</td>
  </tr>
  <tr>
    <td valign="top" height="19"><a href="met_rs_update.asp">Update</a></td>
    <td valign="top" height="19">Saves all changes made to a single record&nbsp;
      in a Recordset object</td>
  </tr>
  <tr>
    <td valign="top" height="15"><a href="met_rs_updatebatch.asp">UpdateBatch</a></td>
    <td valign="top" height="15">Saves all changes in a Recordset to the database.
    Used when working in batch update mode</td>
  </tr>
</table>

<h3>Events</h3>

<p><b>Note:</b>&nbsp; You cannot handle events using VBScript or JScript (only
Visual Basic, Visual C++, and Visual J++ languages can handle events).</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
  <tr valign="top">
    <th width="35%" align="left" valign="top">Event</th>
    <th width="65%" align="left" valign="top">Description</th>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_rs_endofrecordset.asp">EndOfRecordset</a></td>
    <td valign="top">Triggered when you try to move to a record after the last record</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_rs_fetchcomplete.asp">FetchComplete</a></td>
    <td valign="top">Triggered after all records in an asynchronous operation have
      been fetched</td>
  </tr>
  <tr>
    <td valign="top"><a href="ev_rs_fetchprogress.asp">FetchProgress</a></td>
    <td valign="top">Triggered periodically in an asynchronous operation,
	to state how many more records that have been fetched</td>
  </tr>
  <tr>
    <td valign="top"><a href="ev_rs_fieldchange.asp">FieldChangeComplete</a></td>
    <td valign="top">Triggered after the value of a Field object change</td>
  </tr>
  <tr>
    <td valign="top"><a href="ev_rs_move.asp">MoveComplete</a></td>
    <td valign="top">Triggered after the current position in the Recordset has changed</td>
  </tr>
  <tr>
    <td valign="top"><a href="ev_rs_recordchange.asp">RecordChangeComplete</a></td>
    <td valign="top">Triggered after a record has changed</td>
  </tr>
  <tr>
    <td valign="top"><a href="ev_rs_recordsetchange.asp">RecordsetChangeComplete</a></td>
    <td valign="top">Triggered after the Recordset has changed</td>
  </tr>
  <tr>
    <td valign="top"><a href="ev_rs_fieldchange.asp">WillChangeField</a></td>
    <td valign="top">Triggered before the value of a Field object change</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_rs_recordchange.asp">WillChangeRecord</a></td>
    <td valign="top">Triggered before a record change</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_rs_recordsetchange.asp">WillChangeRecordset</a></td>
    <td valign="top">Triggered before a Recordset change</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_rs_move.asp">WillMove</a></td>
    <td valign="top">Triggered before the current position in the Recordset changes</td>