SQLGetStmtAttr (ODBC)

The Microsoft® SQL Server™ ODBC driver extends SQLGetStmtAttr to expose driver-specific statement attributes. All driver-specific attributes are SQLINTEGER values.

The SQL Server ODBC driver SQL_TEXTPTR_LOGGING attribute exposes logging of operations on columns containing text or image data.

Value Description
SQL_TL_OFF Logging operations performed on text, ntext, and image data is disabled.
SQL_TL_ON Default. Logging of operations performed on text, ntext, and image data is enabled.

The SQL_SOPT_SS_CURRENT_COMMAND attribute exposes the current command of a command batch. The return is an integer specifying the location of the command in the batch.

SQL_SOPT_SS_HIDDEN_COLUMNS exposes, in the result set, columns hidden in a SQL Server SELECT FOR BROWSE statement. The driver does not expose these columns by default.

Value Description
SQL_HC_OFF Default. FOR BROWSE columns are hidden from the result set.
SQL_HC_ON Exposes FOR BROWSE columns.

SQL_SOPT_SS_NCOUNT_STATUS indicates the current setting of the NOCOUNT option, which controls whether SQL Server reports the numbers of rows affected by a statement when SQLRowCount is called.

Value Description
SQL_NC_OFF NOCOUNT is OFF. SQLRowCount always returns 0.
SQL_NC_ON NOCOUNT is ON. The counts of rows affected are returned by SQLRowCount.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.