Visual Basic: RDO Data Control
ResultsetType Property
See Also Example Applies To
Returns or sets a value indicating the type of rdoResultsetcursor created or to create.
Syntax
object**.ResultsetType** [= value ]
The ResultsetType property syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
value | A constant or value that specifies a type of rdoResultset, as described in Settings. |
Settings
The settings for value are:
Constant | Value | Description |
rdOpenStatic | 3 | A static-type rdoResultset. |
rdOpenKeyset | 1 | (Default)A keyset-type rdoResultset. |
Remarks
Not all drivers support all types of cursors. For example, SQL Server 6 supports both static and keyset cursors, but SQL Server 4.2 only supports static cursors. If the ODBC driver does not support keyset cursors, they cannot be created by RDO or the RemoteData control. If the RemoteData control can't create the type of rdoResultset cursor requested, RDO builds one of the types that can be created and returns the cursor type in the ResultsetType property.
If you don't specify a ResultsetType before the RemoteData control creates the rdoResultset, a keyset type rdoResultset is created.
If you create an rdoResultset and set the Resultset property with this new object, the ResultsetType property of the RemoteData control is set to the Type property of the new rdoResultset.