ODBCDatabase.ScrollableCursor
From Xojo Documentation
Property (As Boolean )
aODBCDatabase.ScrollableCursor = newBooleanValue
or
BooleanValue = aODBCDatabase.ScrollableCursor
Supported for all project types and targets.
or
BooleanValue = aODBCDatabase.ScrollableCursor
Supported for all project types and targets.
This property can be set to True in order to cause cursors opened using SQLSelect to be “scrollable.” A RecordSet with a scrollable cursor can be navigated in both the forward and backward directions (i.e., using MovePrevious in addition to MoveNext). The default behavior is for a cursor to be non-scrollable (forward only).
This property only has an effect if supported by the underlying ODBC driver.