From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

Property (As Boolean )
aODBCDatabase.ScrollableCursor = newBooleanValue
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.