ondatasetcomplete Event

See Also            Applies To

Occurs when the Recordset has finished being downloaded from the server.

Syntax

objRS_ondatasetcomplete

Parameters

object

A Recordset script object.

Remarks

The ondatasetcomplete event fires when a Recordset has cached all its data on the client (when the scripting platform is IE 4.0) or when the Recordset is completely available (in ASP) . All the data is programmatically accessible through the Recordset script object. This function is particularly interesting when binding data on the IE4 client, because by default, the data is asynchronous; you may want to make sure that all of the data has been transferred prior to doing a particular action.

Example

Sub myRS_ondatasetcomplete()
'assuming there is at least one row of data
   myRS.movelast()
   msgbox "The first column of data in the last row is " & myRS.fields.getValue(0)
End Sub