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();
}