Specifies the type of cursor
to use when opening the record set.
Syntax
Reference_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.
|
|
|
|