Sets various Microsoft® ActiveX® Data Objects (ADO) connection options for the Recordset design-time control. These are the same option settings you can make for ADO Command objects in the data environment.
For more information on ADO recordset management, cursor types, and Command objects, see ADO Reference.
Cursor type
Select the type of cursor you want - Dynamic, Forward Only, KeySet, or Static.
If your Scripting Platform setting is Client (IE 4.0 DHTML), Static is the only available setting.
Cursor location
Select the cursor location you want:
| Setting | Description |
| None | no cursor |
| Use server-side cursor | The cursor is managed by your database server |
| Use client-side cursor | The cursor is managed by your Web server |
| Use client batch cursor | You can update multiple recordsets in a batch |
Note This property setting is only available for ASP pages and if your Scripting Platform setting for this Recordset control is Server (ASP). It is disabled if your Scripting Platform setting is Client (IE 4.0 DHTML).
Lock type
Select the type of record locking you want - Batch Optimistic, Optimistic, Pessimistic, or Read-Only. Pessimistic locking is available only for server-side cursors and only for certain types of databases.
Cache size
Enter the number of records from the recordset that you want to have cached in memory when the recordset is opened. Sets the CacheSize property of the control.
Command timeout
Enter the number of seconds you want to wait before the ADO command contained in this Recordset control times out during execution. The Command objects stored in Recordset controls contain database objects, such as views or stored procedures or explicit SQL statements, that execute ADO commands against the database.
Prepare before execution
Check this box if you want the ADO command contained in this Recordset control to be compiled before it is executed. This is useful, for example, if the command will be executed several times on this page.
Max records
Enter the maximum number of records in the database you want the ADO command contained in this Recordset control to be executed against. Select All records to execute the command against all the records in the database, or enter a number of records in the box to the right. The ADO command will be executed against the number of records you specify, starting with the first record in the recordset.
ODBC call syntax
Presents the syntax that will be used to call stored procedures in ODBC databases. This setting is read-only.