|Navigation: Templates > Templates by Topic > ADO > ADO Code Templates >====== ADORecordsetOpen code template ======|
This code template will call the Open method of the associated Recordset object with parameters specified in the template 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 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).