Implicit setting of scrolling cursor attributes

Certain attributes are set implicitly when your application sets specific attributes. The supported ODBC scrollable cursor attributes set implicitly are as follows:

Application sets attribute to

Other attributes set implicitly

SQL_ATTR_CONCURRENCY to SQL_CONCUR_READ_ONLY

SQL_ATTR_CURSOR_SENSITIVITY to SQL_INSENSITIVE

SQL_ATTR_CONCURRENCY to SQL_CONCUR_LOCK

SQL_ATTR_CURSOR_SENSITIVITY to SQL_SENSITIVE

SQL_ATTR_CURSOR_SCROLLABLE to SQL_NONSCROLLABLE

SQL_ATTR_CURSOR_TYPE to SQL_CURSOR_FORWARD_ONLY

SQL_ATTR_CURSOR_SENSITIVITY to SQL_INSENSITIVE

SQL_ATTR_CONCURRENCY to SQL_CONCUR_READ_ONLY SQL_ATTR_CURSOR_TYPE to SQL_CURSOR_STATIC

SQL_ATTR_CURSOR_TYPE to SQL_CURSOR_FORWARD_ONLY

SQL_ATTR_CURSOR_SCROLLABLE to SQL_NONSCROLLABLE

SQL_ATTR_CURSOR_TYPE to SQL_CURSOR_STATIC

SQL_ATTR_CURSOR_SCROLLABLE to SQL_SCROLLABLE