ondatasetchanged Event

See Also            Applies To

Occurs whenever there is a change made to the Recordset object.

Syntax

objRS_ondatasetchanged

Parameters

object

A Recordset script object.

Remarks

The ondatasetchanged event is fired under two circumstances:

• After a new data set is requested.
  
  
• When the current data set has been altered (for example, added or deleted).

When the event occurs, data may not be available, but the recordset can be used to obtain the metadata for the data set. Metadata includes the list of fields and their types. Web authors can create truly dynamic pages using metadata.

Methods that cause a change to the Recordset object include the addRecord, deleteRecord, and updateRecord methods.

Example

The following sample script adds the list of fields provided by a DSO to a drop-down list, cboSort. When the user selects an item in the drop-down list, the data is sorted by the selected field.

This script handles the ondatasetchanged event for the Recordset name myRS, and adds the fields name to a listbox control.

Sub myRS_ondatasetchanged()
dim iCount
   for iCount = 0 to myRS.fields.getCount() -1 
      lstFieldList.addItem myRS.fields.getName(iCount)
   next
End Sub