Specifies the type of cursor
to use when opening the record set.
SyntaxReference_Syntax.cursorType = "forwardOnly | keyset | dynamic | static | unspecified"
Values
Type
|
Values
|
String
|
forwardOnly (default)
keyset
dynamic
static
unspecified
Identical
to a static cursor, except that scrolling occurs only in a forward
direction. This improves performance when you need to make only
one pass through a record set.
keyset
dynamic
static
unspecified
Similar
to a dynamic cursor, except that records that other users add are
not visible. Data changes by other users are visible.
dynamic
static
unspecified
Additions,
changes, and deletions by other users are visible, and all types
of movement through the record set are permitted, except for bookmarks,
if the provider does not support them.
A static
copy of a set of records that can be used to find data or generate
reports. Additions, changes, or deletions by other users are not
visible.
The
type of cursor is not specified.
|
|
|
|