Provides a mechanism for making direct calls to the Microsoft SQL Server API, and some methods for setting access module-specific properties.
More...
#include <rw/db/msqsrc/msqsysh.h>
Class RWDBMsSqlLibSystemHandle provides methods for setting and retrieving options that affect performance. It also contains the SQLHDBC
used by the RWDBConnection.
- Note
- Use of this class reduces an application's portability.
- Synopsis
#include <rw/db/msqsrc/msqsysh.h>
Provides a mechanism for making direct calls to the Microsoft SQL Server API, and some methods for se...
Definition msqsysh.h:72
- Example
- If it is necessary for your application to make calls directly to the Microsoft SQL Server driver API, proceed as in the following example.
#include <rw/db/msqsrc/msqsysh.h>
SQLHDBC sqlhdbc = handle->
hdbc();
Represents an explicit database connection object that can be used in place of the implicit database ...
Definition connect.h:81
RWDBSystemHandle * systemHandle() const
- Note
- When using runtime loading of the DB Access Module for Microsoft SQL Server, the SQLHDBC is not available. For information, see the DB Access Module for Microsoft SQL Server User's Guide.
◆ cursorType() [1/2]
SQLUINTEGER RWDBMsSqlLibSystemHandle::cursorType |
( |
| ) |
const |
|
inline |
Returns the type of cursor in use. The default value is SQL_CURSOR_KEYSET_DRIVEN
.
◆ cursorType() [2/2]
RWDBStatus RWDBMsSqlLibSystemHandle::cursorType |
( |
SQLUINTEGER | value | ) |
|
|
inline |
Sets the cursor type to value. The cursor types that can be set are SQL_CURSOR_KEYSET_DRIVEN
, SQL_CURSOR_STATIC
, SQL_CURSOR_FORWARD_ONLY
, and SQL_CURSOR_DYNAMIC
.
◆ hdbc()
SQLHDBC RWDBMsSqlLibSystemHandle::hdbc |
( |
| ) |
const |
◆ logTextUpdates() [1/2]
bool RWDBMsSqlLibSystemHandle::logTextUpdates |
( |
| ) |
const |
|
inline |
Returns true
if the client library is to log updates to text
, ntext
, and image
columns. This behavior is enabled by default.
◆ logTextUpdates() [2/2]
RWDBStatus RWDBMsSqlLibSystemHandle::logTextUpdates |
( |
bool | value | ) |
|
|
inline |
Changes the behavior for logging updates to text
, ntext
, and image
columns. A value of false
disables logging updates.
◆ textSize() [1/2]
SQLULEN RWDBMsSqlLibSystemHandle::textSize |
( |
| ) |
const |
|
inline |
Returns the maximum length, in bytes, of text that a SELECT
statement can return for text
, ntext
, and image
data. The default is 2,147,483,647 for the Microsoft SQL Server ODBC driver, but may vary for other drivers.
◆ textSize() [2/2]
RWDBStatus RWDBMsSqlLibSystemHandle::textSize |
( |
SQLULEN | size | ) |
|
|
inline |
Sets the maximum length, in bytes, of text that a SELECT
statement can return for text
, ntext
and image
data, and returns an RWDBStatus indicating whether the operation succeeded.