Reference_Syntax.cursorType = “forwardOnly | keyset | dynamic | static | unspecified”
• forwardOnly (default)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.
• Similar to a dynamic cursor, except that records that other users add are not visible. Data changes by other users are visible.
• 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.