Visual Basic: RDO Data Control
KeysetSize Property (Remote Data)
See Also Example Applies To
Returns or sets a value indicating the number of rows in the keyset buffer.
Syntax
object**.KeysetSize** [= value]
The KeysetSize property syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
value | A Long expression as described in Settings. |
Settings
The settings for value must be greater than or equal to the RowsetSize property.
Remarks
The KeysetSize property is a value that specifies the number of rows in the keyset for a keyset- or dynamic-typerdoResultsetcursor. If the keyset size is 0 (the default), the cursor is fully keyset-driven. If the keyset size is greater than 0, the cursor is mixed (keyset-driven within the keyset and dynamic outside the keyset).
If KeysetSize is a value greater than RowsetSize, the value defines the number of rows in the keyset that are to be buffered by the driver.
Not all ODBC data sources support keyset cursors.
Note Because version 2.5 of the Microsoft SQL Server ODBC driver does not support mixed-style cursors, if you set a value, KeysetSize is reset to 0 and the driver returns error 01S02: "Option value changed.
"
Warning When using rdConcurLock concurrency (pessimistic), the KeysetSize determines the number of rows locked when the cursor is first opened. The entire keyset remains locked as long as the cursor remains open.