open Method

See Also            Applies To

Opens a Recordset object.

Syntax

object.open()

Parameters

object

A Recordset script object.

Remarks

Use the setRecordSource method to set the connection properties before opening a Recordset object. Use the isOpen method to determine if a Recordset object is open.

Example

This shows how to change the where clause of a query, by using a value from a Textbox.

function btnQuery_onclick()
{   
   if ( RS1.isOpen() )
       RS1.close();   // must close the recordset before changing the SQLText
   RS1.setSQLText('Select * from TABLE1 where (ID =' + txtQuery.value + ')');
   RS1.open();
}