SourcePro® API Reference Guide

 
Loading...
Searching...
No Matches

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>

Inheritance diagram for RWDBMsSqlLibSystemHandle:
RWDBSystemHandle

Public Member Functions

SQLUINTEGER cursorType () const
 
RWDBStatus cursorType (SQLUINTEGER value)
 
SQLHDBC hdbc () const
 
bool logTextUpdates () const
 
RWDBStatus logTextUpdates (bool value)
 
SQLULEN textSize () const
 
RWDBStatus textSize (SQLULEN size)
 

Detailed Description

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>
(RWDBMsSqlLibSystemHandle*)myConnection.systemHandle();
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>
RWDBConnection conn = myDbase.connection();
SQLHDBC sqlhdbc = handle->hdbc();
// Use sqlhdbc for MS SQL Server ODBC API calls.
Represents an explicit database connection object that can be used in place of the implicit database ...
Definition connect.h:81
RWDBSystemHandle * systemHandle() const
SQLHDBC hdbc() 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.

Member Function Documentation

◆ 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

Returns the SQLHDBC encapsulated by the respective RWDBConnection.

◆ 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.

Copyright © 2024 Rogue Wave Software, Inc., a Perforce company. All Rights Reserved.