| **Navigation:**  [[templates.htm|Templates]] > [[templates by topic.htm|Templates by Topic]] > ADO > ADO Code Templates >====== ADORecordsetOpen code template ====== | [[tplcodeadorecordsetgetpagesize.htm|{{btn_prev_n.gif|Previous page}}]][[templates by topic.htm|{{btn_home_n.gif|Return to chapter overview}}]][[tplcodeadorecordsetputcachesize.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

This code template will call the **Open** method of the associated Recordset object with parameters specified in the template [[tplextensionadorecordsetobject.htm|extension]].

**Recordset Open Method tab**

Specify the **Cursor** and **Lock** types provided in the drop list. These settings should be found in your native ADO data source documentation. You may also specify additional **Execute Options** if necessary.

**Recordset Query Parameter**

This section allows you to "complete" or modify the default SQL statement, provided that the associated recordset has a command type of //adCmdText//. (See the Command Type tab control in the [[tplextensionadorecordsetobject.htm|ADO RecordSet Object Extension Template]])

The purpose is to give you an opportunity to modify the default SQL statement. For example, if the recordset was set to "SELECT * FROM Customer" in order to generate the proper buffer contents, you may need to filter the contents in another procedure (e.g., load a recordset in a procedure for lookup purposes after some user input).