onbeforeopen Event

See Also            Applies To

Occurs right before a Recordset object is opened.

Syntax

objRS_onbeforeopen

Parameters

object

A Recordset script object.

Remarks

Anytime a recordset is open, either automatically as indicated at design time, or through the open method, the onbeforeopen event is called. This event is useful if you want to change the SQL statement of the recordset, or set parameters.

To specify that a recordset is to be automatically opened, select the Automatically open the Recordset option on the Implementation tab of the Recordset design-time control's Property Pages dialog box.

Example

The following is sample server script (ASP).

function myRS_onbeforeopen()
{
   myRS.setParameter(1,"ParameterValue");
   // parameters for stored procedures are 1-based (the 0 parameter stores the Return Value)
}