Loading...
Searching...
No Matches
Harlinn::ODBC::Statement Class Reference
#include <HODBC.h>
Inheritance diagram for Harlinn::ODBC::Statement:
Collaboration diagram for Harlinn::ODBC::Statement:
Public Types | |
| using | Base = SqlHandle<ODBC::HandleType::Statement> |
Public Member Functions | |
| Statement () | |
| Result | BindColumn (SQLUSMALLINT columnNumber, NativeType targetType, SQLPOINTER targetValue, SQLLEN targetValueMaxLength, SQLLEN *nullIndicatorOrLength) const |
| Result | BindBooleanColumn (SQLUSMALLINT columnNumber, bool *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindBooleanColumn (SQLUSMALLINT columnNumber, DBBoolean &dbValue) const |
| Result | BindSByteColumn (SQLUSMALLINT columnNumber, SByte *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindSByteColumn (SQLUSMALLINT columnNumber, DBSByte &dbValue) const |
| Result | BindByteColumn (SQLUSMALLINT columnNumber, Byte *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindByteColumn (SQLUSMALLINT columnNumber, DBByte &dbValue) const |
| Result | BindInt16Column (SQLUSMALLINT columnNumber, Int16 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindInt16Column (SQLUSMALLINT columnNumber, DBInt16 &dbValue) const |
| Result | BindUInt16Column (SQLUSMALLINT columnNumber, UInt16 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindUInt16Column (SQLUSMALLINT columnNumber, DBUInt16 &dbValue) const |
| Result | BindInt32Column (SQLUSMALLINT columnNumber, Int32 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindInt32Column (SQLUSMALLINT columnNumber, DBInt32 &dbValue) const |
| Result | BindUInt32Column (SQLUSMALLINT columnNumber, UInt32 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindUInt32Column (SQLUSMALLINT columnNumber, DBUInt32 &dbValue) const |
| Result | BindInt64Column (SQLUSMALLINT columnNumber, Int64 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindInt64Column (SQLUSMALLINT columnNumber, DBInt64 &dbValue) const |
| Result | BindUInt64Column (SQLUSMALLINT columnNumber, UInt64 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindUInt64Column (SQLUSMALLINT columnNumber, DBUInt64 &dbValue) const |
| Result | BindSingleColumn (SQLUSMALLINT columnNumber, float *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindSingleColumn (SQLUSMALLINT columnNumber, DBSingle &dbValue) const |
| Result | BindDoubleColumn (SQLUSMALLINT columnNumber, double *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindDoubleColumn (SQLUSMALLINT columnNumber, DBDouble &dbValue) const |
| Result | BindDateTimeColumn (SQLUSMALLINT columnNumber, DateTime *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindDateTimeColumn (SQLUSMALLINT columnNumber, DBDateTime &dbValue) const |
| Result | BindTimeSpanColumn (SQLUSMALLINT columnNumber, TimeSpan *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindTimeSpanColumn (SQLUSMALLINT columnNumber, DBTimeSpan &dbValue) const |
| Result | BindGuidColumn (SQLUSMALLINT columnNumber, Guid *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindGuidColumn (SQLUSMALLINT columnNumber, DBGuid &dbValue) const |
| Result | BindCurrencyColumn (SQLUSMALLINT columnNumber, Currency *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindCurrencyColumn (SQLUSMALLINT columnNumber, DBCurrency &dbValue) const |
| Result | BindCharColumn (SQLUSMALLINT columnNumber, SQLPOINTER targetAddress, SQLLEN targetAddressMaxLength, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindLongColumn (SQLUSMALLINT columnNumber, Int32 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindShortColumn (SQLUSMALLINT columnNumber, Int16 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindTimeColumn (SQLUSMALLINT columnNumber, ODBC::Time *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindTime2Column (SQLUSMALLINT columnNumber, ODBC::Time2 *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindIntervalColumn (SQLUSMALLINT columnNumber, ODBC::Interval *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindTimeStampColumn (SQLUSMALLINT columnNumber, ODBC::TimeStamp *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindTimeStampOffsetColumn (SQLUSMALLINT columnNumber, ODBC::TimeStampOffset *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindNumericColumn (SQLUSMALLINT columnNumber, ODBC::Numeric *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindMoneyColumn (SQLUSMALLINT columnNumber, ODBC::Money *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| Result | BindRowVersionColumn (SQLUSMALLINT columnNumber, ODBC::RowVersion *targetAddress, SQLLEN *nullIndicatorOrActualLength) const |
| template<size_t maxSize> | |
| Result | BindBinaryColumn (SQLUSMALLINT columnNumber, FixedDBBinary< maxSize > *targetAddress) const |
| template<size_t maxSize> | |
| Result | BindStringColumn (SQLUSMALLINT columnNumber, FixedDBWideString< maxSize > *targetAddress) const |
| template<size_t maxSize> | |
| Result | BindStringColumn (SQLUSMALLINT columnNumber, FixedDBAnsiString< maxSize > *targetAddress) const |
| Result | BindParameter (SQLUSMALLINT parameterNumber, ODBC::ParameterDirection parameterDirection, NativeType valueType, SqlType parameterType, SQLULEN columnSize, SQLSMALLINT decimalDigits, SQLPOINTER parameterValue, SQLLEN parameterValueBufferLength, SQLLEN *lengthOrIndicator) const |
| Binds a buffer to a parameter marker in an SQL statement. BindParameter supports binding to a Unicode C data type, even if the underlying driver does not support Unicode data. | |
| Result | BindBooleanParameter (SQLUSMALLINT parameterNumber, bool *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindBooleanParameter (SQLUSMALLINT parameterNumber, const bool *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindBooleanParameter (SQLUSMALLINT parameterNumber, bool *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindBooleanParameter (SQLUSMALLINT parameterNumber, const bool *parameterValue) const |
| Result | BindBooleanParameter (SQLUSMALLINT parameterNumber, DBBoolean ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindBooleanParameter (SQLUSMALLINT parameterNumber, const DBBoolean ¶meterValue) const |
| Result | BindSByteParameter (SQLUSMALLINT parameterNumber, SByte *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindSByteParameter (SQLUSMALLINT parameterNumber, const SByte *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindSByteParameter (SQLUSMALLINT parameterNumber, SByte *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindSByteParameter (SQLUSMALLINT parameterNumber, const SByte *parameterValue) const |
| Result | BindSByteParameter (SQLUSMALLINT parameterNumber, DBSByte ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindSByteParameter (SQLUSMALLINT parameterNumber, const DBSByte ¶meterValue) const |
| Result | BindByteParameter (SQLUSMALLINT parameterNumber, Byte *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindByteParameter (SQLUSMALLINT parameterNumber, const Byte *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindByteParameter (SQLUSMALLINT parameterNumber, Byte *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindByteParameter (SQLUSMALLINT parameterNumber, const Byte *parameterValue) const |
| Result | BindByteParameter (SQLUSMALLINT parameterNumber, DBByte ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindByteParameter (SQLUSMALLINT parameterNumber, const DBByte ¶meterValue) const |
| Result | BindInt16Parameter (SQLUSMALLINT parameterNumber, Int16 *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindInt16Parameter (SQLUSMALLINT parameterNumber, const Int16 *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindInt16Parameter (SQLUSMALLINT parameterNumber, Int16 *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindInt16Parameter (SQLUSMALLINT parameterNumber, const Int16 *parameterValue) const |
| Result | BindInt16Parameter (SQLUSMALLINT parameterNumber, DBInt16 ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindInt16Parameter (SQLUSMALLINT parameterNumber, const DBInt16 ¶meterValue) const |
| Result | BindUInt16Parameter (SQLUSMALLINT parameterNumber, UInt16 *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindUInt16Parameter (SQLUSMALLINT parameterNumber, const UInt16 *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindUInt16Parameter (SQLUSMALLINT parameterNumber, UInt16 *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindUInt16Parameter (SQLUSMALLINT parameterNumber, const UInt16 *parameterValue) const |
| Result | BindUInt16Parameter (SQLUSMALLINT parameterNumber, DBUInt16 ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindUInt16Parameter (SQLUSMALLINT parameterNumber, const DBUInt16 ¶meterValue) const |
| Result | BindInt32Parameter (SQLUSMALLINT parameterNumber, Int32 *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindInt32Parameter (SQLUSMALLINT parameterNumber, const Int32 *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindInt32Parameter (SQLUSMALLINT parameterNumber, Int32 *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindInt32Parameter (SQLUSMALLINT parameterNumber, const Int32 *parameterValue) const |
| Result | BindInt32Parameter (SQLUSMALLINT parameterNumber, DBInt32 ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindInt32Parameter (SQLUSMALLINT parameterNumber, const DBInt32 ¶meterValue) const |
| Result | BindUInt32Parameter (SQLUSMALLINT parameterNumber, UInt32 *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindUInt32Parameter (SQLUSMALLINT parameterNumber, const UInt32 *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindUInt32Parameter (SQLUSMALLINT parameterNumber, UInt32 *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindUInt32Parameter (SQLUSMALLINT parameterNumber, const UInt32 *parameterValue) const |
| Result | BindUInt32Parameter (SQLUSMALLINT parameterNumber, DBUInt32 ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindUInt32Parameter (SQLUSMALLINT parameterNumber, const DBUInt32 ¶meterValue) const |
| Result | BindInt64Parameter (SQLUSMALLINT parameterNumber, Int64 *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindInt64Parameter (SQLUSMALLINT parameterNumber, const Int64 *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindInt64Parameter (SQLUSMALLINT parameterNumber, Int64 *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindInt64Parameter (SQLUSMALLINT parameterNumber, const Int64 *parameterValue) const |
| Result | BindInt64Parameter (SQLUSMALLINT parameterNumber, DBInt64 ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindInt64Parameter (SQLUSMALLINT parameterNumber, const DBInt64 ¶meterValue) const |
| Result | BindUInt64Parameter (SQLUSMALLINT parameterNumber, UInt64 *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindUInt64Parameter (SQLUSMALLINT parameterNumber, const UInt64 *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindUInt64Parameter (SQLUSMALLINT parameterNumber, UInt64 *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindUInt64Parameter (SQLUSMALLINT parameterNumber, const UInt64 *parameterValue) const |
| Result | BindUInt64Parameter (SQLUSMALLINT parameterNumber, DBUInt64 ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindUInt64Parameter (SQLUSMALLINT parameterNumber, const DBUInt64 ¶meterValue) const |
| template<typename T > requires std::is_enum_v<T> | |
| Result | BindEnumParameter (SQLUSMALLINT parameterNumber, T *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| template<typename T > requires std::is_enum_v<T> | |
| Result | BindEnumParameter (SQLUSMALLINT parameterNumber, const T *parameterValue, SQLLEN *nullIndicator) const |
| template<typename T > requires std::is_enum_v<T> | |
| Result | BindEnumParameter (SQLUSMALLINT parameterNumber, T *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| template<typename T > requires std::is_enum_v<T> | |
| Result | BindEnumParameter (SQLUSMALLINT parameterNumber, const T *parameterValue) const |
| template<typename T > requires std::is_enum_v<T> | |
| Result | BindEnumParameter (SQLUSMALLINT parameterNumber, DBEnum< T > ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| template<typename T > requires std::is_enum_v<T> | |
| Result | BindEnumParameter (SQLUSMALLINT parameterNumber, const DBEnum< T > ¶meterValue) const |
| Result | BindParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, char *parameterValue, SQLLEN parameterValueBufferLength, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| Result | BindLongParameter (SQLUSMALLINT parameterNumber, UInt32 *parameterValue, SQLLEN *nullIndicator=nullptr, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| Result | BindShortParameter (SQLUSMALLINT parameterNumber, UInt16 *parameterValue, SQLLEN *nullIndicator=nullptr, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| Result | BindSingleParameter (SQLUSMALLINT parameterNumber, float *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindSingleParameter (SQLUSMALLINT parameterNumber, const float *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindSingleParameter (SQLUSMALLINT parameterNumber, float *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindSingleParameter (SQLUSMALLINT parameterNumber, const float *parameterValue) const |
| Result | BindSingleParameter (SQLUSMALLINT parameterNumber, DBSingle ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindSingleParameter (SQLUSMALLINT parameterNumber, const DBSingle ¶meterValue) const |
| Result | BindDoubleParameter (SQLUSMALLINT parameterNumber, Double *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindDoubleParameter (SQLUSMALLINT parameterNumber, const double *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindDoubleParameter (SQLUSMALLINT parameterNumber, double *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindDoubleParameter (SQLUSMALLINT parameterNumber, const double *parameterValue) const |
| Result | BindDoubleParameter (SQLUSMALLINT parameterNumber, DBDouble ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindDoubleParameter (SQLUSMALLINT parameterNumber, const DBDouble ¶meterValue) const |
| Result | BindGuidParameter (SQLUSMALLINT parameterNumber, Guid *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindGuidParameter (SQLUSMALLINT parameterNumber, const Guid *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindGuidParameter (SQLUSMALLINT parameterNumber, Guid *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindGuidParameter (SQLUSMALLINT parameterNumber, const Guid *parameterValue) const |
| Result | BindGuidParameter (SQLUSMALLINT parameterNumber, DBGuid ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindGuidParameter (SQLUSMALLINT parameterNumber, const DBGuid ¶meterValue) const |
| Result | BindDateTimeParameter (SQLUSMALLINT parameterNumber, DateTime *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindDateTimeParameter (SQLUSMALLINT parameterNumber, const DateTime *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindDateTimeParameter (SQLUSMALLINT parameterNumber, DateTime *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindDateTimeParameter (SQLUSMALLINT parameterNumber, const DateTime *parameterValue) const |
| Result | BindDateTimeParameter (SQLUSMALLINT parameterNumber, DBDateTime ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindDateTimeParameter (SQLUSMALLINT parameterNumber, const DBDateTime ¶meterValue) const |
| Result | BindTimeSpanParameter (SQLUSMALLINT parameterNumber, TimeSpan *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindTimeSpanParameter (SQLUSMALLINT parameterNumber, const TimeSpan *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindTimeSpanParameter (SQLUSMALLINT parameterNumber, TimeSpan *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindTimeSpanParameter (SQLUSMALLINT parameterNumber, const TimeSpan *parameterValue) const |
| Result | BindTimeSpanParameter (SQLUSMALLINT parameterNumber, DBTimeSpan ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindTimeSpanParameter (SQLUSMALLINT parameterNumber, const DBTimeSpan ¶meterValue) const |
| Result | BindCurrencyParameter (SQLUSMALLINT parameterNumber, Currency *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindCurrencyParameter (SQLUSMALLINT parameterNumber, const Currency *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindCurrencyParameter (SQLUSMALLINT parameterNumber, Currency *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindCurrencyParameter (SQLUSMALLINT parameterNumber, const Currency *parameterValue) const |
| Result | BindCurrencyParameter (SQLUSMALLINT parameterNumber, DBCurrency ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindCurrencyParameter (SQLUSMALLINT parameterNumber, const DBCurrency ¶meterValue) const |
| Result | BindTimeStampParameter (SQLUSMALLINT parameterNumber, SQLSMALLINT precisionOfFraction, ODBC::TimeStamp *parameterValue, SQLLEN *nullIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindTimeStampParameter (SQLUSMALLINT parameterNumber, SQLSMALLINT precisionOfFraction, const TimeStamp *parameterValue, SQLLEN *nullIndicator) const |
| Result | BindTimeStampParameter (SQLUSMALLINT parameterNumber, SQLSMALLINT precisionOfFraction, TimeStamp *parameterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindTimeStampParameter (SQLUSMALLINT parameterNumber, SQLSMALLINT precisionOfFraction, const TimeStamp *parameterValue) const |
| Result | BindTimeStampParameter (SQLUSMALLINT parameterNumber, SQLSMALLINT precisionOfFraction, DBTimeStamp ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::InputOutput) const |
| Result | BindTimeStampParameter (SQLUSMALLINT parameterNumber, SQLSMALLINT precisionOfFraction, const DBTimeStamp ¶meterValue) const |
| Result | BindVarCharParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, char *parameterValue, SQLLEN parameterValueBufferLength, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| Result | BindVarCharParameter (SQLUSMALLINT parameterNumber, const AnsiString ¶meterValue, SQLLEN *lengthOrIndicator=nullptr, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| template<size_t maxSize> | |
| Result | BindVarCharParameter (SQLUSMALLINT parameterNumber, FixedDBAnsiString< maxSize > ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| template<size_t maxSize> | |
| Result | BindFixedDBAnsiStringParameter (SQLUSMALLINT parameterNumber, FixedDBAnsiString< maxSize > ¶meterValue, ODBC::ParameterDirection parameterDirection) const |
| template<size_t maxSize> | |
| Result | BindFixedDBAnsiStringParameter (SQLUSMALLINT parameterNumber, const FixedDBAnsiString< maxSize > ¶meterValue) const |
| Result | BindNVarCharParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, wchar_t *parameterValue, SQLLEN parameterValueBufferLength, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| template<size_t maxSize> | |
| Result | BindNVarCharParameter (SQLUSMALLINT parameterNumber, FixedDBWideString< maxSize > ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| template<size_t maxSize> | |
| Result | BindFixedDBWideStringParameter (SQLUSMALLINT parameterNumber, FixedDBWideString< maxSize > ¶meterValue, ODBC::ParameterDirection parameterDirection) const |
| template<size_t maxSize> | |
| Result | BindFixedDBWideStringParameter (SQLUSMALLINT parameterNumber, const FixedDBWideString< maxSize > ¶meterValue) const |
| Result | BindNVarCharParameter (SQLUSMALLINT parameterNumber, const WideString ¶meterValue, SQLLEN *lengthOrIndicator=nullptr, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| Result | BindVarBinaryParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, Byte *parameterValue, SQLLEN parameterValueBufferLength, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| Result | BindVarBinaryParameter (SQLUSMALLINT parameterNumber, std::vector< Byte > ¶meterValue, SQLLEN *lengthOrIndicator=nullptr, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| template<size_t maxSize> | |
| Result | BindVarBinaryParameter (SQLUSMALLINT parameterNumber, FixedDBBinary< maxSize > ¶meterValue, ODBC::ParameterDirection parameterDirection=ODBC::ParameterDirection::Input) const |
| template<size_t maxSize> | |
| Result | BindFixedDBBinaryParameter (SQLUSMALLINT parameterNumber, FixedDBBinary< maxSize > ¶meterValue, ODBC::ParameterDirection parameterDirection) const |
| template<size_t maxSize> | |
| Result | BindFixedDBBinaryParameter (SQLUSMALLINT parameterNumber, const FixedDBBinary< maxSize > ¶meterValue) const |
| Result | BindBinaryParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, Binary ¶meterValue, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindBinaryParameter (SQLUSMALLINT parameterNumber, Binary ¶meterValue, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindBinaryParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, const Binary ¶meterValue, SQLLEN *lengthOrIndicator) const |
| Result | BindBinaryParameter (SQLUSMALLINT parameterNumber, const Binary ¶meterValue, SQLLEN *lengthOrIndicator=nullptr) const |
| Result | BindBinaryParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, const Binary ¶meterValue) const |
| Result | BindBinaryParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, const DBBinary ¶meterValue) const |
| Result | BindBinaryParameter (SQLUSMALLINT parameterNumber, const DBBinary ¶meterValue) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, AnsiString ¶meterValue, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, const AnsiString ¶meterValue, SQLLEN *lengthOrIndicator) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, AnsiString ¶meterValue, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, const AnsiString ¶meterValue, SQLLEN *lengthOrIndicator) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, AnsiString ¶meterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, const AnsiString ¶meterValue) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, const DBAnsiString ¶meterValue) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, const DBAnsiString ¶meterValue) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, WideString ¶meterValue, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, const WideString ¶meterValue, SQLLEN *lengthOrIndicator) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, WideString ¶meterValue, SQLLEN *lengthOrIndicator, ODBC::ParameterDirection parameterDirection) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, const WideString ¶meterValue, SQLLEN *lengthOrIndicator) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, WideString ¶meterValue, ODBC::ParameterDirection parameterDirection) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, const WideString ¶meterValue) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, SQLULEN columnSize, const DBWideString ¶meterValue) const |
| Result | BindStringParameter (SQLUSMALLINT parameterNumber, const DBWideString ¶meterValue) const |
| Result | BulkOperations (ODBC::BulkOperation bulkOperation) const |
| Result | CloseCursor () |
| Result | GetColumnAttribute (SQLUSMALLINT columnNumber, SQLUSMALLINT fieldIdentifier, SQLPOINTER value, SQLSMALLINT valueMaxLength, SQLSMALLINT *valueActualLength, SQLLEN *numericAttributeValue) const |
| Result | GetColumnAttributeAnsi (SQLUSMALLINT columnNumber, SQLUSMALLINT fieldIdentifier, SQLPOINTER value, SQLSMALLINT valueMaxLength, SQLSMALLINT *valueActualLength, SQLLEN *numericAttributeValue) const |
| Int64 | GetInt64ColumnAttribute (SQLUSMALLINT columnNumber, SQLUSMALLINT fieldIdentifier) const |
| bool | GetBooleanColumnAttribute (SQLUSMALLINT columnNumber, SQLUSMALLINT fieldIdentifier) const |
| WideString | GetWideStringColumnAttribute (SQLUSMALLINT columnNumber, SQLUSMALLINT fieldIdentifier) const |
| bool | ColumnIsAutoIncrement (SQLUSMALLINT columnNumber) const |
| WideString | ColumnBaseName (SQLUSMALLINT columnNumber) const |
| WideString | ColumnBaseTableName (SQLUSMALLINT columnNumber) const |
| Returns the name of the base table that contains the column. If the base table name cannot be defined or is not applicable, then this variable contains an empty string. | |
| bool | ColumnIsCaseSensitive (SQLUSMALLINT columnNumber) const |
| Returns true if the column is treated as case-sensitive for collations and comparisons, otherwise false. | |
| WideString | ColumnCatalogName (SQLUSMALLINT columnNumber) const |
| The catalog of the table that contains the column. The returned value is implementation-defined if the column is an expression or if the column is part of a view. If the data source does not support catalogs or the catalog name cannot be determined, an empty string is returned. | |
| ODBC::SqlType | ColumnConciseType (SQLUSMALLINT columnNumber) const |
| Returns the concise data type. | |
| size_t | ColumnCount () const |
| Returns the number of columns available in the result set. This returns 0 if there are no columns in the result set. | |
| SQLLEN | ColumnDisplaySize (SQLUSMALLINT columnNumber) const |
| Returns the maximum number of characters required to display data from the column. | |
| bool | ColumnHasFixedPrecisionAndScale (SQLUSMALLINT columnNumber) const |
| Returns true if the column has a fixed precision and nonzero scale that are data source-specific. | |
| WideString | ColumnLabel (SQLUSMALLINT columnNumber) const |
| SQLLEN | ColumnLength (SQLUSMALLINT columnNumber) const |
| WideString | ColumnLiteralPrefix (SQLUSMALLINT columnNumber) const |
| Returns the character or characters that the driver recognizes as a prefix for a literal of this data type. This field contains an empty string for a data type for which a literal prefix is not applicable. | |
| WideString | ColumnLiteralSuffix (SQLUSMALLINT columnNumber) const |
| Returns the character or characters that the driver recognizes as a suffix for a literal of this data type. This field contains an empty string for a data type for which a literal suffix is not applicable. | |
| WideString | ColumnLocalTypeName (SQLUSMALLINT columnNumber) const |
| Returns the localized (native language) name for the data type that may be different from the regular name of the data type. If there is no localized name, then an empty string is returned. This field is for display purposes only. The character set of the string is locale-dependent and is typically the default character set of the server. | |
| WideString | ColumnName (SQLUSMALLINT columnNumber) const |
| The column alias, if it applies. If the column alias does not apply, the column name is returned. | |
| std::optional< bool > | ColumnIsNullable (SQLUSMALLINT columnNumber) const |
| Returns a std::optional<bool> object indicating whether the column accepts NULL values or not. If has_value() returns false, it is not known whether the column accepts NULL values or not. When has_value() returns true, value() returns true if the column accepts NULL values, otherwise value() returns false, indicating that the column does not accept null values. | |
| Int64 | ColumnNumericPrecisionRadix (SQLUSMALLINT columnNumber) const |
| If the column is an approximate numeric this function returns the value 2, if the column is an exact numeric data type, this field contains a value of 10, for all other types this function returns 0. | |
| Int64 | ColumnBinaryLength (SQLUSMALLINT columnNumber) const |
| Returns the length, in bytes, of a character string or binary data type. For fixed-length character or binary types, this is the actual length in bytes. For variable-length character or binary types, this is the maximum length in bytes. This value does not include the null terminator. | |
| Int64 | ColumnPrecision (SQLUSMALLINT columnNumber) const |
| Returns a numeric value that for a numeric data type denotes the applicable precision. For data types SqlType::Time, SqlType::TimeStamp, and all the interval data types that represent a time interval, its value is the applicable precision of the fractional seconds component. | |
| Int64 | ColumnScale (SQLUSMALLINT columnNumber) const |
| Returns a numeric value that is the applicable scale for a numeric data type. For SqlType::Decimal and SqlType::Numeric data types, this is the defined scale. It is undefined for all other data types. | |
| WideString | ColumnSchemaName (SQLUSMALLINT columnNumber) const |
| Returns the schema of the table that contains the column. The returned value is implementation-defined if the column is an expression or if the column is part of a view. If the data source does not support schemas or the schema name cannot be determined, an empty string is returned. | |
| SearchPredicates | ColumnSearchPredicates (SQLUSMALLINT columnNumber) const |
| WideString | ColumnTableName (SQLUSMALLINT columnNumber) const |
| Returns the name of the table that contains the column. The returned value is implementation-defined if the column is an expression or if the column is part of a view. | |
| ODBC::SqlType | ColumnType (SQLUSMALLINT columnNumber) const |
| Returns a numeric value that specifies the SQL data type. | |
| WideString | ColumnTypeName (SQLUSMALLINT columnNumber) const |
| Returns the data source-dependent data type name. | |
| bool | ColumnIsUnnamed (SQLUSMALLINT columnNumber) const |
| Returns true if the column is unnamed, otherwise false. | |
| bool | ColumnIsUnsigned (SQLUSMALLINT columnNumber) const |
| Returns true if the column is unsigned, or not numeric, otherwise false. | |
| std::optional< bool > | ColumnIsUpdatable (SQLUSMALLINT columnNumber) const |
| Returns a std::optional<bool> object indicating whether the column can be updated or not. | |
| Result | ColumnPrivileges (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameMaxLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameMaxLength, const SQLWCHAR *tableName, SQLSMALLINT tableNameMaxLength, const SQLWCHAR *columnName, SQLSMALLINT columnNameMaxLength) const |
| Returns a list of columns and associated privileges for the specified table. The driver returns the information as a result set on the Statement. | |
| Result | ColumnPrivileges (const SQLCHAR *catalogName, SQLSMALLINT catalogNameMaxLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameMaxLength, const SQLCHAR *tableName, SQLSMALLINT tableNameMaxLength, const SQLCHAR *columnName, SQLSMALLINT columnNameMaxLength) const |
| Result | Columns (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameMaxLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameMaxLength, const SQLWCHAR *tableName, SQLSMALLINT tableNameMaxLength, const SQLWCHAR *columnName, SQLSMALLINT columnNameMaxLength) const |
| Result | Columns (const SQLCHAR *catalogName, SQLSMALLINT catalogNameMaxLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameMaxLength, const SQLCHAR *tableName, SQLSMALLINT tableNameMaxLength, const SQLCHAR *columnName, SQLSMALLINT columnNameMaxLength) const |
| Result | DescribeColumn (SQLUSMALLINT columnNumber, SQLWCHAR *columnName, SQLSMALLINT columnNameMaxLength, SQLSMALLINT *columnNameActualLength, SQLSMALLINT *dataType, SQLULEN *columnSize, SQLSMALLINT *decimalDigits, ODBC::Nullable *nullable) const |
| Result | DescribeColumn (SQLUSMALLINT columnNumber, SQLCHAR *columnName, SQLSMALLINT columnNameMaxLength, SQLSMALLINT *columnNameActualLength, SQLSMALLINT *dataType, SQLULEN *columnSize, SQLSMALLINT *decimalDigits, ODBC::Nullable *nullable) const |
| Result | DescribeParameter (SQLUSMALLINT parameterNumber, SqlType *dataType, SQLULEN *parameterSize, SQLSMALLINT *decimalDigits, ODBC::Nullable *nullable) const |
| ParameterDescription | DescribeParameter (SQLUSMALLINT parameterNumber) const |
| Result | ExecDirect (const SQLWCHAR *statementText, SQLINTEGER statementTextLength=SQL_NTS) const |
| Result | ExecDirect (const SQLCHAR *statementText, SQLINTEGER statementTextLength=SQL_NTS) const |
| Result | Execute () const |
| template<typename ReaderType > requires std::is_base_of_v<DataReader, ReaderType> | |
| std::unique_ptr< ReaderType > | CreateReader () const |
| template<typename ReaderType = DataReader> requires std::is_base_of_v<DataReader, ReaderType> | |
| std::unique_ptr< ReaderType > | ExecuteReader () const |
| template<typename ReaderType = DataReader> requires std::is_base_of_v<DataReader, ReaderType> | |
| std::unique_ptr< ReaderType > | ExecuteReader (const SQLWCHAR *statementText, SQLINTEGER statementTextLength=SQL_NTS) const |
| template<typename ReaderType = DataReader> requires std::is_base_of_v<DataReader, ReaderType> | |
| std::unique_ptr< ReaderType > | ExecuteReader (const SQLCHAR *statementText, SQLINTEGER statementTextLength=SQL_NTS) const |
| template<typename ReaderType = DataReader, SimpleStringLike StringT> requires std::is_base_of_v<DataReader, ReaderType> | |
| std::unique_ptr< ReaderType > | ExecuteReader (const StringT &str) const |
| Result | Fetch () const |
| Result | FetchScroll (ODBC::FetchOrientation fetchOrientation, SQLLEN fetchOffset) const |
| Result | ForeignKeys (const SQLWCHAR *primaryKeyCatalogName, SQLSMALLINT primaryKeyCatalogNameLength, const SQLWCHAR *primaryKeySchemaName, SQLSMALLINT primaryKeySchemaNameLength, const SQLWCHAR *primaryKeyTableName, SQLSMALLINT primaryKeyTableNameLength, const SQLWCHAR *foreignKeyCatalogName, SQLSMALLINT foreignKeyCatalogNameLength, const SQLWCHAR *foreignKeySchemaName, SQLSMALLINT foreignKeySchemaNameLength, const SQLWCHAR *foreignKeyTableName, SQLSMALLINT foreignKeyTableNameLength) const |
| Result | ForeignKeys (const SQLCHAR *primaryKeyCatalogName, SQLSMALLINT primaryKeyCatalogNameLength, const SQLCHAR *primaryKeySchemaName, SQLSMALLINT primaryKeySchemaNameLength, const SQLCHAR *primaryKeyTableName, SQLSMALLINT primaryKeyTableNameLength, const SQLCHAR *foreignKeyCatalogName, SQLSMALLINT foreignKeyCatalogNameLength, const SQLCHAR *foreignKeySchemaName, SQLSMALLINT foreignKeySchemaNameLength, const SQLCHAR *foreignKeyTableName, SQLSMALLINT foreignKeyTableNameLength) const |
| Result | Unbind () const |
| Sets the SQL_DESC_COUNT field of the ARD to 0, releasing all column buffers bound by BindColumn for the statement. | |
| Result | ResetParameters () const |
| Sets the SQL_DESC_COUNT field of the APD to 0, releasing all parameter buffers set by BindParameter for the statement. | |
| Result | CursorName (SQLWCHAR *cursorName, SQLSMALLINT cursorNameMaxLength, SQLSMALLINT *cursorNameActualLength) const |
| Result | CursorName (SQLCHAR *cursorName, SQLSMALLINT cursorNameMaxLength, SQLSMALLINT *cursorNameActualLength) const |
| Result | GetData (SQLUSMALLINT columnOrParameterNumber, NativeType targetValueDataType, SQLPOINTER targetValue, SQLLEN targetValueMaxLength, SQLLEN *nullIndicatorOrTargetValueActualLength) const |
| DBBoolean | GetDBBoolean (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBBoolean. | |
| DBByte | GetDBByte (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBByte. | |
| DBSByte | GetDBSByte (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBSByte. | |
| DBInt16 | GetDBInt16 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBInt16. | |
| DBUInt16 | GetDBUInt16 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBUInt16. | |
| DBInt32 | GetDBInt32 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBInt32. | |
| DBUInt32 | GetDBUInt32 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBUInt32. | |
| DBInt64 | GetDBInt64 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBInt64. | |
| DBUInt64 | GetDBUInt64 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBUInt64. | |
| DBNumeric | GetDBNumeric (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a std::optional<Numeric>. | |
| DBDecimal | GetDBDecimal (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBDecimal. | |
| DBSingle | GetDBSingle (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBSingle. | |
| DBDouble | GetDBDouble (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBDouble. | |
| DBCurrency | GetDBCurrency (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBCurrency. | |
| DBDateTime | GetDBDateTime (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBDateTime. | |
| DBTimeStampOffset | GetDBTimeStampOffset (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBTimestampOffset. | |
| DBDate | GetDBDate (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBDate. | |
| DBTime | GetDBTime (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBTime. | |
| DBTimeSpan | GetDBTimeSpan (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBTimeSpan. | |
| DBWideString | GetDBWideString (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBWideString. | |
| DBAnsiString | GetDBAnsiString (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBAnsiString. | |
| DBBinary | GetDBBinary (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBBinary. | |
| DBGuid | GetDBGuid (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DBGuid. | |
| DBRowVersion | GetDBRowVersion (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a std::optional<RowVersion>. | |
| bool | GetBoolean (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a bool. | |
| Byte | GetByte (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a Byte. | |
| SByte | GetSByte (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a SByte. | |
| Int16 | GetInt16 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as an Int16. | |
| UInt16 | GetUInt16 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as an UInt16. | |
| Int32 | GetInt32 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as an Int32. | |
| UInt32 | GetUInt32 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as an UInt32. | |
| Int64 | GetInt64 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as an Int64. | |
| UInt64 | GetUInt64 (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as an UInt64. | |
| Numeric | GetNumeric (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a Numeric. | |
| Numeric | GetDecimal (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a Numeric. | |
| float | GetSingle (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a float. | |
| double | GetDouble (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a double. | |
| Currency | GetCurrency (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a Currency. | |
| DateTime | GetDateTime (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a DateTime. | |
| TimeStampOffset | GetTimeStampOffset (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a TimestampOffset. | |
| Date | GetDate (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a Date. | |
| Time | GetTime (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a Time. | |
| TimeSpan | GetTimeSpan (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a TimeSpan. | |
| WideString | GetWideString (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a WideString. | |
| AnsiString | GetAnsiString (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as an AnsiString. | |
| Binary | GetBinary (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a std::vector<Byte>. | |
| Guid | GetGuid (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a Guid. | |
| RowVersion | GetRowVersion (SQLUSMALLINT columnNumber) const |
| Gets the value of the specified column as a RowVersion. | |
| Result | GetAttributeW (SQLINTEGER attributeId, SQLPOINTER value, SQLINTEGER valueBufferLength, SQLINTEGER *valueActualLength) const |
| Retrieves the current setting of a statement attribute. | |
| UInt64 | GetUInt64Attribute (SQLINTEGER attributeId) const |
| Retrieves the current setting of a UInt64 valued statement attribute. | |
| Int64 | GetInt64Attribute (SQLINTEGER attributeId) const |
| Retrieves the current setting of a Int64 valued statement attribute. | |
| SQLPOINTER | GetPointerAttribute (SQLINTEGER attributeId) const |
| Retrieves the current setting of a pointer valued statement attribute. | |
| bool | GetBooleanAttribute (SQLINTEGER attributeId) const |
| Retrieves the current setting of a boolean valued statement attribute. | |
| Descriptor | GetDescriptorAttribute (SQLINTEGER attributeId) const |
| Retrieves the current setting of a descriptor valued statement attribute. | |
| template<typename T > requires std::is_enum_v<T> | |
| T | GetEnumAttribute (SQLINTEGER attributeId) const |
| Retrieves the current setting of a UInt64 valued statement attribute as an enum value. | |
| Result | GetAttributeA (SQLINTEGER attributeId, SQLPOINTER value, SQLINTEGER valueBufferLength, SQLINTEGER *valueActualLength) const |
| Retrieves the current setting of a statement attribute. | |
| Result | SetAttributeW (SQLINTEGER attributeId, SQLPOINTER value, SQLINTEGER valueLength) const |
| Sets attributes related to a statement. | |
| Result | SetUInt64Attribute (SQLINTEGER attributeId, UInt64 value) const |
| Sets an UInt64 valued attribute. | |
| Result | SetInt64Attribute (SQLINTEGER attributeId, Int64 value) const |
| Sets an Int64 valued attribute. | |
| Result | SetBooleanAttribute (SQLINTEGER attributeId, bool value) const |
| Sets an boolean valued attribute. | |
| Result | SetPointerAttribute (SQLINTEGER attributeId, SQLPOINTER value) const |
| Sets an pointer valued attribute. | |
| Result | SetDescriptorAttribute (SQLINTEGER attributeId, SQLHANDLE value) const |
| Sets a descriptor valued attribute. | |
| Result | SetDescriptorAttribute (SQLINTEGER attributeId, const Descriptor &value) const |
| Sets a descriptor valued attribute. | |
| template<typename T > requires std::is_enum_v<T> | |
| Result | SetEnumAttribute (SQLINTEGER attributeId, T value) const |
| Sets an UInt64 valued attribute valued attribute to the value from an enumeration. | |
| Result | SetAttributeA (SQLINTEGER attributeId, SQLPOINTER value, SQLINTEGER valueLength) const |
| Sets attributes related to a statement. | |
| Result | SetApplicationParameterDescriptor (const Descriptor &applicationParameterDescriptor) const |
| Result | SetApplicationParameterDescriptor (SQLHANDLE applicationParameterDescriptor) const |
| Descriptor | ApplicationParameterDescriptor () const |
| Retrieves the application parameter descriptor. | |
| Result | SetApplicationRowDescriptor (const Descriptor &applicationRowDescriptor) const |
| Result | SetApplicationRowDescriptor (SQLHANDLE applicationRowDescriptor) const |
| Descriptor | ApplicationRowDescriptor () const |
| Retrieves the application row descriptor. | |
| Result | SetAsyncEnabled (bool asyncEnable) const |
| Enables or disables asynchronous statement execution. | |
| bool | AsyncEnabled () const |
| Returns true if asynchronous statement execution is enabled, otherwise false. | |
| Result | SetAsyncEventHandle (HANDLE asyncEventHandle) const |
| Assigns the Windows event handle that will get notified on asynchronous completion. | |
| Result | SetAsyncEventHandle (const EventWaitHandle &asyncEventHandle) const |
| Assigns the Windows event handle that will get notified on asynchronous completion. | |
| HANDLE | AsyncEventHandle () const |
| Retrieves the Windows event handle assigned to the SQL_ATTR_ASYNC_STMT_EVENT attribute, or nullptr if no event handle has previously been assigned to this attribute. | |
| Result | SetConcurrency (ODBC::Concurrency concurrency) const |
| Assigns the cursor concurrency model to be used with the statement. | |
| ODBC::Concurrency | Concurrency () const |
| Retrieves the cursor concurrency model that will be used with this statement. | |
| Result | SetCursorScrollable (bool cursorScrollable) const |
| bool | CursorScrollable () const |
| Result | SetCursorSensitivity (ODBC::CursorSensitivity cursorSensitivity) const |
| ODBC::CursorSensitivity | CursorSensitivity () const |
| Result | SetCursorType (ODBC::CursorType cursorType) const |
| ODBC::CursorType | CursorType () const |
| Result | SetAutoPopulateImplementationParameterDescriptor (bool autoPopulateImplementationParameterDescriptor) const |
| bool | AutoPopulateImplementationParameterDescriptor () const |
| SQLULEN * | FetchBookmarkPointer () const |
| ODBC::Descriptor | ImplementationParameterDescriptor () const |
| ODBC::Descriptor | ImplementationRowDescriptor () const |
| Result | SetKeysetSize (SQLULEN keysetSize) const |
| SQLULEN | KeysetSize () const |
| Result | SetMaxColumnLength (SQLULEN maxColumnLength) const |
| SQLULEN | MaxColumnLength () const |
| Result | SetMaxRows (SQLULEN maxRows) const |
| SQLULEN | MaxRows () const |
| Result | SetMetadataIdentifiers (bool metadataIdentifiers) const |
| bool | MetadataIdentifiers () const |
| Result | SetNoScan (bool noScan) const |
| bool | NoScan () const |
| Result | SetParameterBindOffsetPointer (SQLULEN *paramBindOffsetPointer) const |
| SQLULEN * | ParameterBindOffsetPointer () const |
| Result | SetParameterBindByColumn () const |
| bool | ParameterBindByColumn () const |
| Result | SetParameterRowSize (SQLULEN rowSize) const |
| bool | ParameterRowSize () const |
| Result | SetParameterOperationPointer (SQLULEN *paramOperationPointer) const |
| SQLULEN * | ParameterOperationPointer () const |
| Result | SetParameterArraySize (UInt64 parameterArraySize) const |
| UInt64 | ParameterArraySize () const |
| Result | SetParameterStatusArray (SQLUSMALLINT *parameterStatusArray) const |
| SQLUSMALLINT * | ParameterStatusArray () const |
| Result | SetParametersProcessedPointer (SQLULEN *parametersProcessed) const |
| SQLULEN * | ParametersProcessedPointer () const |
| Result | SetParameterSetSize (SQLULEN parameterSetSize) const |
| SQLULEN | ParameterSetSize () const |
| Result | SetQueryTimeout (const TimeSpan &timeout) const |
| Result | SetQueryTimeout (const UInt64 timeout) const |
| TimeSpan | QueryTimeout () const |
| Result | SetRetrieveData (bool retrieveData) const |
| bool | RetrieveData () const |
| Result | SetRowArraySize (UInt64 rowArraySize) const |
| UInt64 | RowArraySize () const |
| Result | SetRowBindOffsetPointer (SQLULEN *rowBindOffsetPointer) const |
| SQLULEN * | RowBindOffsetPointer () const |
| Result | SetRowBindByColumn () const |
| bool | RowBindByColumn () const |
| Result | SetRowSize (SQLULEN rowSize) const |
| SQLULEN | RowSize () const |
| SQLULEN | RowNumber () const |
| Result | SetRowOperationPointer (SQLULEN *paramOperationPointer) const |
| SQLULEN * | RowOperationPointer () const |
| Result | SetRowStatusPointer (SQLUSMALLINT *rowStatusPointer) const |
| SQLUSMALLINT * | RowStatusPointer () const |
| Result | SetRowsFetchedPointer (SQLULEN *rowsFetched) const |
| SQLULEN * | RowsFetchedPointer () const |
| Result | SetSimulateCursor (ODBC::SimulateCursor simulateCursor) const |
| ODBC::SimulateCursor | SimulateCursor () const |
| Result | SetUseBookmarks (bool useBookmarks) const |
| bool | UseBookmarks () const |
| Result | GetTypeInfoW (SQLSMALLINT dataType) const |
| Result | GetTypeInfoA (SQLSMALLINT dataType) const |
| Result | MoreResults () const |
| void | ConsumeResults () const |
| Result | NumParams (SQLSMALLINT *result) const |
| SQLSMALLINT | NumParams () const |
| Result | NumResultCols (SQLSMALLINT *result) const |
| Result | ParamData (SQLPOINTER *valuePointer) const |
| Result | Prepare (const SQLWCHAR *statement, SQLINTEGER statementLength=SQL_NTS) const |
| Result | Prepare (const SQLCHAR *statement, SQLINTEGER statementLength=SQL_NTS) const |
| Result | PrimaryKeys (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLWCHAR *tableName, SQLSMALLINT tableNameLength) const |
| Result | PrimaryKeys (const SQLCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLCHAR *tableName, SQLSMALLINT tableNameLength) const |
| Result | ProcedureColumns (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLWCHAR *procedureName, SQLSMALLINT procedureNameLength, const SQLWCHAR *columnName, SQLSMALLINT columnNameLength) const |
| Result | ProcedureColumns (const SQLCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLCHAR *procedureName, SQLSMALLINT procedureNameLength, const SQLCHAR *columnName, SQLSMALLINT columnNameLength) const |
| Result | Procedures (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLWCHAR *procedureName, SQLSMALLINT procedureNameLength) const |
| Result | Procedures (const SQLCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLCHAR *procedureName, SQLSMALLINT procedureNameLength) const |
| Result | PutData (SQLPOINTER data, SQLLEN nullIndicatorOrDataLength) const |
| Result | RowCount (SQLLEN *result) const |
| SQLLEN | RowCount () const |
| Result | SetCursorName (const SQLWCHAR *cursorName, SQLSMALLINT cursorNameLength) const |
| Result | SetCursorName (const SQLCHAR *cursorName, SQLSMALLINT cursorNameLength) const |
| Result | SetPosition (SQLSETPOSIROW rowNumber, SQLUSMALLINT operation, SQLUSMALLINT lockType) const |
| Result | SpecialColumns (SQLSMALLINT identifierType, const SQLWCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLWCHAR *tableName, SQLSMALLINT tableNameLength, SQLSMALLINT scope, SQLSMALLINT nullable) const |
| Result | SpecialColumns (SQLSMALLINT identifierType, const SQLCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLCHAR *tableName, SQLSMALLINT tableNameLength, SQLSMALLINT scope, SQLSMALLINT nullable) const |
| Result | Statistics (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLWCHAR *tableName, SQLSMALLINT tableNameLength, SQLSMALLINT unique, SQLSMALLINT options) const |
| Result | Statistics (const SQLCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLCHAR *tableName, SQLSMALLINT tableNameLength, SQLSMALLINT unique, SQLSMALLINT options) const |
| Result | TablePrivileges (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLWCHAR *tableName, SQLSMALLINT tableNameLength) const |
| Result | TablePrivileges (const SQLCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLCHAR *tableName, SQLSMALLINT tableNameLength) const |
| Result | Tables (const SQLWCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLWCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLWCHAR *tableName, SQLSMALLINT tableNameLength, const SQLWCHAR *tableTypes, SQLSMALLINT tableTypesLength) const |
| Result | Tables (const SQLCHAR *catalogName, SQLSMALLINT catalogNameLength, const SQLCHAR *schemaName, SQLSMALLINT schemaNameLength, const SQLCHAR *tableName, SQLSMALLINT tableNameLength, const SQLCHAR *tableTypes, SQLSMALLINT tableTypesLength) const |
 Public Member Functions inherited from Harlinn::ODBC::SqlHandle< ODBC::HandleType::Statement > | |
| constexpr | SqlHandle () noexcept |
| SqlHandle (const SqlHandle &other)=delete | |
| constexpr | SqlHandle (SqlHandle &&other) noexcept |
| ~SqlHandle () | |
| SqlHandle & | operator= (const SqlHandle &other)=delete |
| constexpr SqlHandle & | operator= (SqlHandle &&other) noexcept |
| constexpr SQLHANDLE | Handle () const noexcept |
| void | Close () noexcept |
| Result | Cancel () const |
| Result | CompleteAsync (RETCODE *asyncRetCode) const |
Private Member Functions | |
| constexpr | Statement (SQLHANDLE sqlHandle, bool destructorClosesHandle=true) |
| Result | FreeStmt (SQLUSMALLINT option) const |
Friends | |
| class | Connection |
Additional Inherited Members | |
| Static Public Attributes inherited from Harlinn::ODBC::SqlHandle< ODBC::HandleType::Statement > | |
| static constexpr ODBC::HandleType | HandleType |
| static constexpr SQLHANDLE | InvalidHandle |
| Protected Member Functions inherited from Harlinn::ODBC::SqlHandle< ODBC::HandleType::Statement > | |
| constexpr | SqlHandle (SQLHANDLE sqlHandle, bool destructorClosesHandle) noexcept |
| void | SetHandle (SQLHANDLE sqlHandle, bool destructorClosesHandle) |
| void | ThrowException (SQLRETURN sqlReturn) const |
| void | ThrowException (SQLRETURN sqlReturn, const wchar_t *function, const wchar_t *file, int line) const |
| Static Protected Member Functions inherited from Harlinn::ODBC::SqlHandle< ODBC::HandleType::Statement > | |
| static SQLHANDLE | AllocateHandle (SQLHANDLE inputHandle=SQL_NULL_HANDLE, ODBC::HandleType handleType=HandleType) |
Detailed Description
The Statement class is a wrapper for the ODBC statement handle.
A statement is most easily thought of as an SQL statement, such as SELECT * FROM Employee. However, a statement is more than just an SQL statement - it consists of all of the information associated with that SQL statement, such as any result sets created by the statement and parameters used in the execution of the statement. A statement does not even need to have an application-defined SQL statement. For example, when a catalog function such as SQLTables is executed on a statement, it executes a predefined SQL statement that returns a list of table names.
Each statement is identified by a statement handle. A statement is associated with a single connection, and there can be multiple statements on that connection. Some drivers limit the number of active statements they support; the SQL_MAX_CONCURRENT_ACTIVITIES option in SQLGetInfo specifies how many active statements a driver supports on a single connection. A statement is defined to be active if it has results pending, where results are either a result set or the count of rows affected by an INSERT, UPDATE, or DELETE statement, or data is being sent with multiple calls to SQLPutData.
Within a piece of code that implements ODBC (the Driver Manager or a driver), the statement handle identifies a structure that contains statement information, such as:
- The statement's state
- The current statement-level diagnostics
- The addresses of the application variables bound to the statement's parameters and result set columns
- The current settings of each statement attribute
Statement handles are used in most ODBC functions. Notably, they are used in the functions to bind parameters and result set columns (SQLBindParameter and SQLBindCol), prepare and execute statements (SQLPrepare, SQLExecute, and SQLExecDirect), retrieve metadata (SQLColAttribute and SQLDescribeCol), fetch results (SQLFetch), and retrieve diagnostics (SQLGetDiagField and SQLGetDiagRec). They are also used in catalog functions (SQLColumns, SQLTables, and so on) and a number of other functions.
Statement handles are allocated with SQLAllocHandle and freed with SQLFreeHandle.
Member Typedef Documentation
◆ Base
Constructor & Destructor Documentation
◆ Statement() [1/2]
|
inline |
◆ Statement() [2/2]
|
inlineexplicitconstexprprivate |
Member Function Documentation
◆ ApplicationParameterDescriptor()
|
inline |
Retrieves the application parameter descriptor.
- Returns
- The application parameter descriptor
◆ ApplicationRowDescriptor()
|
inline |
Retrieves the application row descriptor.
- Returns
- The application row descriptor.
◆ AsyncEnabled()
|
inline |
Returns true if asynchronous statement execution is enabled, otherwise false.
- Returns
◆ AsyncEventHandle()
|
inline |
Retrieves the Windows event handle assigned to the SQL_ATTR_ASYNC_STMT_EVENT attribute, or nullptr if no event handle has previously been assigned to this attribute.
- Returns
- The event handle, or nullptr if none has been set on the statement.
◆ AutoPopulateImplementationParameterDescriptor()
|
inline |
◆ BindBinaryColumn()
template<size_t maxSize>
|
inline |
◆ BindBinaryParameter() [1/7]
|
inline |
◆ BindBinaryParameter() [2/7]
|
inline |
◆ BindBinaryParameter() [3/7]
|
inline |
◆ BindBinaryParameter() [4/7]
|
inline |
◆ BindBinaryParameter() [5/7]
|
inline |
◆ BindBinaryParameter() [6/7]
|
inline |
◆ BindBinaryParameter() [7/7]
|
inline |
◆ BindBooleanColumn() [1/2]
|
inline |
◆ BindBooleanColumn() [2/2]
|
inline |
◆ BindBooleanParameter() [1/6]
|
inline |
◆ BindBooleanParameter() [2/6]
|
inline |
◆ BindBooleanParameter() [3/6]
|
inline |
◆ BindBooleanParameter() [4/6]
|
inline |
◆ BindBooleanParameter() [5/6]
|
inline |
◆ BindBooleanParameter() [6/6]
|
inline |
◆ BindByteColumn() [1/2]
|
inline |
◆ BindByteColumn() [2/2]
|
inline |
◆ BindByteParameter() [1/6]
|
inline |
◆ BindByteParameter() [2/6]
|
inline |
◆ BindByteParameter() [3/6]
|
inline |
◆ BindByteParameter() [4/6]
|
inline |
◆ BindByteParameter() [5/6]
|
inline |
◆ BindByteParameter() [6/6]
|
inline |
◆ BindCharColumn()
|
inline |
◆ BindColumn()
|
inline |
◆ BindCurrencyColumn() [1/2]
|
inline |
◆ BindCurrencyColumn() [2/2]
|
inline |
◆ BindCurrencyParameter() [1/6]
|
inline |
◆ BindCurrencyParameter() [2/6]
|
inline |
◆ BindCurrencyParameter() [3/6]
|
inline |
◆ BindCurrencyParameter() [4/6]
|
inline |
◆ BindCurrencyParameter() [5/6]
|
inline |
◆ BindCurrencyParameter() [6/6]
|
inline |
◆ BindDateTimeColumn() [1/2]
|
inline |
◆ BindDateTimeColumn() [2/2]
|
inline |
◆ BindDateTimeParameter() [1/6]
|
inline |
◆ BindDateTimeParameter() [2/6]
|
inline |
◆ BindDateTimeParameter() [3/6]
|
inline |
◆ BindDateTimeParameter() [4/6]
|
inline |
◆ BindDateTimeParameter() [5/6]
|
inline |
◆ BindDateTimeParameter() [6/6]
|
inline |
◆ BindDoubleColumn() [1/2]
|
inline |
◆ BindDoubleColumn() [2/2]
|
inline |
◆ BindDoubleParameter() [1/6]
|
inline |
◆ BindDoubleParameter() [2/6]
|
inline |
◆ BindDoubleParameter() [3/6]
|
inline |
◆ BindDoubleParameter() [4/6]
|
inline |
◆ BindDoubleParameter() [5/6]
|
inline |
◆ BindDoubleParameter() [6/6]
|
inline |
◆ BindEnumParameter() [1/6]
|
inline |
◆ BindEnumParameter() [2/6]
|
inline |
◆ BindEnumParameter() [3/6]
|
inline |
◆ BindEnumParameter() [4/6]
|
inline |
◆ BindEnumParameter() [5/6]
|
inline |
◆ BindEnumParameter() [6/6]
|
inline |
◆ BindFixedDBAnsiStringParameter() [1/2]
template<size_t maxSize>
|
inline |
◆ BindFixedDBAnsiStringParameter() [2/2]
template<size_t maxSize>
|
inline |
◆ BindFixedDBBinaryParameter() [1/2]
template<size_t maxSize>
|
inline |
◆ BindFixedDBBinaryParameter() [2/2]
template<size_t maxSize>
|
inline |
◆ BindFixedDBWideStringParameter() [1/2]
template<size_t maxSize>
|
inline |
◆ BindFixedDBWideStringParameter() [2/2]
template<size_t maxSize>
|
inline |
◆ BindGuidColumn() [1/2]
|
inline |
◆ BindGuidColumn() [2/2]
|
inline |
◆ BindGuidParameter() [1/6]
|
inline |
◆ BindGuidParameter() [2/6]
|
inline |
◆ BindGuidParameter() [3/6]
|
inline |
◆ BindGuidParameter() [4/6]
|
inline |
◆ BindGuidParameter() [5/6]
|
inline |
◆ BindGuidParameter() [6/6]
|
inline |
◆ BindInt16Column() [1/2]
|
inline |
◆ BindInt16Column() [2/2]
|
inline |
◆ BindInt16Parameter() [1/6]
|
inline |
◆ BindInt16Parameter() [2/6]
|
inline |
◆ BindInt16Parameter() [3/6]
|
inline |
◆ BindInt16Parameter() [4/6]
|
inline |
◆ BindInt16Parameter() [5/6]
|
inline |
◆ BindInt16Parameter() [6/6]
|
inline |
◆ BindInt32Column() [1/2]
|
inline |
◆ BindInt32Column() [2/2]
|
inline |
◆ BindInt32Parameter() [1/6]
|
inline |
◆ BindInt32Parameter() [2/6]
|
inline |
◆ BindInt32Parameter() [3/6]
|
inline |
◆ BindInt32Parameter() [4/6]
|
inline |
◆ BindInt32Parameter() [5/6]
|
inline |
◆ BindInt32Parameter() [6/6]
|
inline |
◆ BindInt64Column() [1/2]
|
inline |
◆ BindInt64Column() [2/2]
|
inline |
◆ BindInt64Parameter() [1/6]
|
inline |
◆ BindInt64Parameter() [2/6]
|
inline |
◆ BindInt64Parameter() [3/6]
|
inline |
◆ BindInt64Parameter() [4/6]
|
inline |
◆ BindInt64Parameter() [5/6]
|
inline |
◆ BindInt64Parameter() [6/6]
|
inline |
◆ BindIntervalColumn()
|
inline |
◆ BindLongColumn()
|
inline |
◆ BindLongParameter()
|
inline |
◆ BindMoneyColumn()
|
inline |
◆ BindNumericColumn()
|
inline |
◆ BindNVarCharParameter() [1/3]
|
inline |
◆ BindNVarCharParameter() [2/3]
template<size_t maxSize>
|
inline |
◆ BindNVarCharParameter() [3/3]
|
inline |
◆ BindParameter() [1/2]
|
inline |
Binds a buffer to a parameter marker in an SQL statement. BindParameter supports binding to a Unicode C data type, even if the underlying driver does not support Unicode data.
- Parameters
-
parameterNumber Parameter number, ordered sequentially in increasing parameter order, starting at 1. parameterDirection The direction of the parameter valueType The native C data type of the parameter. parameterType The SQL data type of the parameter. columnSize The size of the column or expression of the corresponding parameter marker. decimalDigits The decimal digits of the column or expression of the corresponding parameter marker. parameterValue A pointer to a buffer for the parameter's data. parameterValueBufferLength Length of the ParameterValuePtr buffer in bytes. lengthOrIndicator A pointer to a buffer for the parameter's length.
- Returns
◆ BindParameter() [2/2]
|
inline |
◆ BindRowVersionColumn()
|
inline |
◆ BindSByteColumn() [1/2]
|
inline |
◆ BindSByteColumn() [2/2]
|
inline |
◆ BindSByteParameter() [1/6]
|
inline |
◆ BindSByteParameter() [2/6]
|
inline |
◆ BindSByteParameter() [3/6]
|
inline |
◆ BindSByteParameter() [4/6]
|
inline |
◆ BindSByteParameter() [5/6]
|
inline |
◆ BindSByteParameter() [6/6]
|
inline |
◆ BindShortColumn()
|
inline |
◆ BindShortParameter()
|
inline |
◆ BindSingleColumn() [1/2]
|
inline |
◆ BindSingleColumn() [2/2]
|
inline |
◆ BindSingleParameter() [1/6]
|
inline |
◆ BindSingleParameter() [2/6]
|
inline |
◆ BindSingleParameter() [3/6]
|
inline |
◆ BindSingleParameter() [4/6]
|
inline |
◆ BindSingleParameter() [5/6]
|
inline |
◆ BindSingleParameter() [6/6]
|
inline |
◆ BindStringColumn() [1/2]
template<size_t maxSize>
|
inline |
◆ BindStringColumn() [2/2]
template<size_t maxSize>
|
inline |
◆ BindStringParameter() [1/16]
|
inline |
◆ BindStringParameter() [2/16]
|
inline |
◆ BindStringParameter() [3/16]
|
inline |
◆ BindStringParameter() [4/16]
|
inline |
◆ BindStringParameter() [5/16]
|
inline |
◆ BindStringParameter() [6/16]
|
inline |
◆ BindStringParameter() [7/16]
|
inline |
◆ BindStringParameter() [8/16]
|
inline |
◆ BindStringParameter() [9/16]
|
inline |
◆ BindStringParameter() [10/16]
|
inline |
◆ BindStringParameter() [11/16]
|
inline |
◆ BindStringParameter() [12/16]
|
inline |
◆ BindStringParameter() [13/16]
|
inline |
◆ BindStringParameter() [14/16]
|
inline |
◆ BindStringParameter() [15/16]
|
inline |
◆ BindStringParameter() [16/16]
|
inline |
◆ BindTime2Column()
|
inline |
◆ BindTimeColumn()
|
inline |
◆ BindTimeSpanColumn() [1/2]
|
inline |
◆ BindTimeSpanColumn() [2/2]
|
inline |
◆ BindTimeSpanParameter() [1/6]
|
inline |
◆ BindTimeSpanParameter() [2/6]
|
inline |
◆ BindTimeSpanParameter() [3/6]
|
inline |
◆ BindTimeSpanParameter() [4/6]
|
inline |
◆ BindTimeSpanParameter() [5/6]
|
inline |
◆ BindTimeSpanParameter() [6/6]
|
inline |
◆ BindTimeStampColumn()
|
inline |
◆ BindTimeStampOffsetColumn()
|
inline |
◆ BindTimeStampParameter() [1/6]
|
inline |
◆ BindTimeStampParameter() [2/6]
|
inline |
◆ BindTimeStampParameter() [3/6]
|
inline |
◆ BindTimeStampParameter() [4/6]
|
inline |
◆ BindTimeStampParameter() [5/6]
|
inline |
◆ BindTimeStampParameter() [6/6]
|
inline |
◆ BindUInt16Column() [1/2]
|
inline |
◆ BindUInt16Column() [2/2]
|
inline |
◆ BindUInt16Parameter() [1/6]
|
inline |
◆ BindUInt16Parameter() [2/6]
|
inline |
◆ BindUInt16Parameter() [3/6]
|
inline |
◆ BindUInt16Parameter() [4/6]
|
inline |
◆ BindUInt16Parameter() [5/6]
|
inline |
◆ BindUInt16Parameter() [6/6]
|
inline |
◆ BindUInt32Column() [1/2]
|
inline |
◆ BindUInt32Column() [2/2]
|
inline |
◆ BindUInt32Parameter() [1/6]
|
inline |
◆ BindUInt32Parameter() [2/6]
|
inline |
◆ BindUInt32Parameter() [3/6]
|
inline |
◆ BindUInt32Parameter() [4/6]
|
inline |
◆ BindUInt32Parameter() [5/6]
|
inline |
◆ BindUInt32Parameter() [6/6]
|
inline |
◆ BindUInt64Column() [1/2]
|
inline |
◆ BindUInt64Column() [2/2]
|
inline |
◆ BindUInt64Parameter() [1/6]
|
inline |
◆ BindUInt64Parameter() [2/6]
|
inline |
◆ BindUInt64Parameter() [3/6]
|
inline |
◆ BindUInt64Parameter() [4/6]
|
inline |
◆ BindUInt64Parameter() [5/6]
|
inline |
◆ BindUInt64Parameter() [6/6]
|
inline |
◆ BindVarBinaryParameter() [1/3]
template<size_t maxSize>
|
inline |
◆ BindVarBinaryParameter() [2/3]
|
inline |
◆ BindVarBinaryParameter() [3/3]
|
inline |
◆ BindVarCharParameter() [1/3]
|
inline |
◆ BindVarCharParameter() [2/3]
template<size_t maxSize>
|
inline |
◆ BindVarCharParameter() [3/3]
|
inline |
◆ BulkOperations()
|
inline |
◆ CloseCursor()
|
inline |
◆ ColumnBaseName()
|
inline |
Returns the base column name for the result set column. If a base column name does not exist (as in the case of columns that are expressions), then this variable contains an empty string.
- Parameters
-
columnNumber The one-based column number.
- Returns
- the base column name for the result set column
◆ ColumnBaseTableName()
|
inline |
Returns the name of the base table that contains the column. If the base table name cannot be defined or is not applicable, then this variable contains an empty string.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The name of the base table that contains the column.
◆ ColumnBinaryLength()
|
inline |
Returns the length, in bytes, of a character string or binary data type. For fixed-length character or binary types, this is the actual length in bytes. For variable-length character or binary types, this is the maximum length in bytes. This value does not include the null terminator.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The length, in bytes, of a character string or binary data type.
◆ ColumnCatalogName()
|
inline |
The catalog of the table that contains the column. The returned value is implementation-defined if the column is an expression or if the column is part of a view. If the data source does not support catalogs or the catalog name cannot be determined, an empty string is returned.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The name of catalog of the table that contains the column.
◆ ColumnConciseType()
|
inline |
Returns the concise data type.
- Parameters
-
columnNumber The one-based column number.
- Returns
- the concise data type.
◆ ColumnCount()
|
inline |
Returns the number of columns available in the result set. This returns 0 if there are no columns in the result set.
- Returns
- the number of columns available in the result set.
◆ ColumnDisplaySize()
|
inline |
Returns the maximum number of characters required to display data from the column.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The maximum number of characters required to display data from the column.
◆ ColumnHasFixedPrecisionAndScale()
|
inline |
Returns true if the column has a fixed precision and nonzero scale that are data source-specific.
- Parameters
-
columnNumber The one-based column number.
- Returns
- true if the column has a fixed precision and nonzero scale.
◆ ColumnIsAutoIncrement()
|
inline |
Returns true if the column is an autoincrementing column, otherwise false.
This function is valid for numeric data type columns only. An application can insert values into a row containing an autoincrement column, but typically cannot update values in the column.
When an insert is made into an autoincrement column, a unique value is inserted into the column at insert time. The increment is not defined, but is data source-specific. An application should not assume that an autoincrement column starts at any particular point or increments by any particular value.
- Parameters
-
columnNumber The one-based column number.
- Returns
- true if the column is an autoincrementing column, otherwise false.
◆ ColumnIsCaseSensitive()
|
inline |
Returns true if the column is treated as case-sensitive for collations and comparisons, otherwise false.
- Parameters
-
columnNumber The one-based column number.
- Returns
- true if the column is treated as case-sensitive.
◆ ColumnIsNullable()
|
inline |
Returns a std::optional<bool> object indicating whether the column accepts NULL values or not. If has_value() returns false, it is not known whether the column accepts NULL values or not. When has_value() returns true, value() returns true if the column accepts NULL values, otherwise value() returns false, indicating that the column does not accept null values.
- Parameters
-
columnNumber The one-based column number.
- Returns
- A std::optional<bool> object indicating whether the column accepts NULL values or not.
◆ ColumnIsUnnamed()
|
inline |
Returns true if the column is unnamed, otherwise false.
- Parameters
-
columnNumber The one-based column number.
- Returns
- true if the column is unnamed, otherwise false.
◆ ColumnIsUnsigned()
|
inline |
Returns true if the column is unsigned, or not numeric, otherwise false.
- Parameters
-
columnNumber The one-based column number.
- Returns
- true if the column is unsigned, or not numeric, otherwise false.
◆ ColumnIsUpdatable()
|
inline |
Returns a std::optional<bool> object indicating whether the column can be updated or not.
- Parameters
-
columnNumber The one-based column number.
- Returns
- A std::optional<bool> object indicating whether the column can be updated or not.
◆ ColumnLabel()
|
inline |
Returns the column label or title.
If a column does not have a label, the column name is returned. If the column is unlabeled and unnamed, an empty string is returned.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The column label or title.
◆ ColumnLength()
|
inline |
Returns a numeric value that is either the maximum or actual character length of a character string or binary data type. It is the maximum character length for a fixed-length data type, or the actual character length for a variable-length data type. Its value always excludes the null-termination byte that ends the character string.
For the decimal and numeric types, it returns the precision of the column.
The return values for other column types appears consistent, like the function returning 53 for a nullable float column; which is the precision, in bits, for a 64-bit floating point value.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The length of the column value.
◆ ColumnLiteralPrefix()
|
inline |
Returns the character or characters that the driver recognizes as a prefix for a literal of this data type. This field contains an empty string for a data type for which a literal prefix is not applicable.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The literal prefix.
◆ ColumnLiteralSuffix()
|
inline |
Returns the character or characters that the driver recognizes as a suffix for a literal of this data type. This field contains an empty string for a data type for which a literal suffix is not applicable.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The literal suffix.
◆ ColumnLocalTypeName()
|
inline |
Returns the localized (native language) name for the data type that may be different from the regular name of the data type. If there is no localized name, then an empty string is returned. This field is for display purposes only. The character set of the string is locale-dependent and is typically the default character set of the server.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The localized (native language) name for the data type.
◆ ColumnName()
|
inline |
The column alias, if it applies. If the column alias does not apply, the column name is returned.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The column alias or name.
◆ ColumnNumericPrecisionRadix()
|
inline |
If the column is an approximate numeric this function returns the value 2, if the column is an exact numeric data type, this field contains a value of 10, for all other types this function returns 0.
- Parameters
-
columnNumber The one-based column number.
- Returns
- A value indicating whether the column is an exact numeric type, an approximate numeric type, or something else.
◆ ColumnPrecision()
|
inline |
Returns a numeric value that for a numeric data type denotes the applicable precision. For data types SqlType::Time, SqlType::TimeStamp, and all the interval data types that represent a time interval, its value is the applicable precision of the fractional seconds component.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The precision of the column.
◆ ColumnPrivileges() [1/2]
|
inline |
◆ ColumnPrivileges() [2/2]
|
inline |
Returns a list of columns and associated privileges for the specified table. The driver returns the information as a result set on the Statement.
- Parameters
-
catalogName catalogNameMaxLength schemaName schemaNameMaxLength tableName tableNameMaxLength columnName columnNameMaxLength
- Returns
◆ Columns() [1/2]
|
inline |
◆ Columns() [2/2]
|
inline |
◆ ColumnScale()
|
inline |
Returns a numeric value that is the applicable scale for a numeric data type. For SqlType::Decimal and SqlType::Numeric data types, this is the defined scale. It is undefined for all other data types.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The scale of the column.
◆ ColumnSchemaName()
|
inline |
Returns the schema of the table that contains the column. The returned value is implementation-defined if the column is an expression or if the column is part of a view. If the data source does not support schemas or the schema name cannot be determined, an empty string is returned.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The schema of the table that contains the column.
◆ ColumnSearchPredicates()
|
inline |
Returns a value indicating the predicates that can be applied to the column in a WHERE clause.
Returns SearchPredicates::None if the column cannot be used in a WHERE clause.
Returns SearchPredicates::Char if the column can be used in a WHERE clause but only with the LIKE predicate.
Returns SearchPredicates::Basic if the column can be used in a WHERE clause with all the comparison operators except LIKE.
Returns SearchPredicates::Searchable if the column can be used in a WHERE clause with any comparison operator.
- Parameters
-
columnNumber The one-based column number.
- Returns
- A value indicating the predicates that can be applied to the column.
◆ ColumnTableName()
|
inline |
Returns the name of the table that contains the column. The returned value is implementation-defined if the column is an expression or if the column is part of a view.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The name of the table that contains the column.
◆ ColumnType()
|
inline |
Returns a numeric value that specifies the SQL data type.
- Parameters
-
columnNumber The one-based column number.
- Returns
- A numeric value that specifies the SQL data type.
◆ ColumnTypeName()
|
inline |
Returns the data source-dependent data type name.
- Parameters
-
columnNumber The one-based column number.
- Returns
- The data source-dependent data type name.
◆ Concurrency()
|
inline |
Retrieves the cursor concurrency model that will be used with this statement.
- Returns
- A value from the ODBC::Concurrency enumeration
◆ ConsumeResults()
|
inline |
◆ CreateReader()
template<typename ReaderType >
requires std::is_base_of_v<DataReader, ReaderType>
requires std::is_base_of_v<DataReader, ReaderType>
|
inline |
◆ CursorName() [1/2]
|
inline |
◆ CursorName() [2/2]
|
inline |
◆ CursorScrollable()
|
inline |
◆ CursorSensitivity()
|
inline |
◆ CursorType()
|
inline |
◆ DescribeColumn() [1/2]
|
inline |
◆ DescribeColumn() [2/2]
|
inline |
◆ DescribeParameter() [1/2]
|
inline |
◆ DescribeParameter() [2/2]
|
inline |
◆ ExecDirect() [1/2]
|
inline |
◆ ExecDirect() [2/2]
|
inline |
◆ Execute()
|
inline |
◆ ExecuteReader() [1/4]
template<typename ReaderType = DataReader>
requires std::is_base_of_v<DataReader, ReaderType>
requires std::is_base_of_v<DataReader, ReaderType>
|
inline |
◆ ExecuteReader() [2/4]
template<typename ReaderType = DataReader>
requires std::is_base_of_v<DataReader, ReaderType>
requires std::is_base_of_v<DataReader, ReaderType>
|
inline |
◆ ExecuteReader() [3/4]
template<typename ReaderType = DataReader>
requires std::is_base_of_v<DataReader, ReaderType>
requires std::is_base_of_v<DataReader, ReaderType>
|
inline |
◆ ExecuteReader() [4/4]
template<typename ReaderType = DataReader, SimpleStringLike StringT>
requires std::is_base_of_v<DataReader, ReaderType>
requires std::is_base_of_v<DataReader, ReaderType>
|
inline |
◆ Fetch()
|
inline |
◆ FetchBookmarkPointer()
|
inline |
◆ FetchScroll()
|
inline |
◆ ForeignKeys() [1/2]
|
inline |
◆ ForeignKeys() [2/2]
|
inline |
◆ FreeStmt()
|
inlineprivate |
◆ GetAnsiString()
|
inlinenodiscard |
Gets the value of the specified column as an AnsiString.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetAttributeA()
|
inline |
Retrieves the current setting of a statement attribute.
- Parameters
-
attributeId Identifier of the attribute to retrieve. value Pointer to a buffer in which to return the value of the attribute specified in Attribute. If value is nullptr, valueActualLength will still return the total number of bytes (excluding the null-termination character for character data) available to return in the buffer pointed to by value. valueBufferLength If attributeId is an ODBC-defined attribute and value *points to a character string or a binary buffer, this argument should be the length of *value. If attributeId is an ODBC-defined attribute and *value is an integer, valueBufferLength is ignored. If the value returned in *value is a Unicode string, the valueBufferLength argument must be an even number. If attributeId is a driver-defined attribute, the application indicates the nature of the attribute to the Driver Manager by setting the BufferLength argument. valueBufferLength can have the following values: - If *value is a pointer to a character string, then valueBufferLength is the length of the string or SQL_NTS.
- If *value is a pointer to a binary buffer, then the application places the result of the SQL_LEN_BINARY_ATTR(length) macro in valueBufferLength. This places a negative value in valueBufferLength.
- If *value is a pointer to a value other than a character string or binary string, then valueBufferLength should have the value SQL_IS_POINTER.
- If *value contains a fixed-length data type, then valueBufferLength is either SQL_IS_INTEGER or SQL_IS_UINTEGER, as appropriate.
valueActualLength
- Returns
◆ GetAttributeW()
|
inline |
Retrieves the current setting of a statement attribute.
- Parameters
-
attributeId Identifier of the attribute to retrieve. value Pointer to a buffer in which to return the value of the attribute specified in Attribute. If value is nullptr, valueActualLength will still return the total number of bytes (excluding the null-termination character for character data) available to return in the buffer pointed to by value. valueBufferLength If attributeId is an ODBC-defined attribute and value *points to a character string or a binary buffer, this argument should be the length of *value. If attributeId is an ODBC-defined attribute and *value is an integer, valueBufferLength is ignored. If the value returned in *value is a Unicode string, the valueBufferLength argument must be an even number. If attributeId is a driver-defined attribute, the application indicates the nature of the attribute to the Driver Manager by setting the BufferLength argument. valueBufferLength can have the following values: - If *value is a pointer to a character string, then valueBufferLength is the length of the string or SQL_NTS.
- If *value is a pointer to a binary buffer, then the application places the result of the SQL_LEN_BINARY_ATTR(length) macro in valueBufferLength. This places a negative value in valueBufferLength.
- If *value is a pointer to a value other than a character string or binary string, then valueBufferLength should have the value SQL_IS_POINTER.
- If *value contains a fixed-length data type, then valueBufferLength is either SQL_IS_INTEGER or SQL_IS_UINTEGER, as appropriate.
valueActualLength
- Returns
◆ GetBinary()
|
inlinenodiscard |
Gets the value of the specified column as a std::vector<Byte>.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetBoolean()
|
inlinenodiscard |
Gets the value of the specified column as a bool.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetBooleanAttribute()
|
inline |
Retrieves the current setting of a boolean valued statement attribute.
- Parameters
-
attributeId Identifier of the attribute to retrieve.
- Returns
- The value of the attribute.
◆ GetBooleanColumnAttribute()
|
inline |
◆ GetByte()
|
inlinenodiscard |
Gets the value of the specified column as a Byte.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetColumnAttribute()
|
inline |
◆ GetColumnAttributeAnsi()
|
inline |
◆ GetCurrency()
|
inlinenodiscard |
Gets the value of the specified column as a Currency.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetData()
|
inline |
◆ GetDate()
|
inlinenodiscard |
Gets the value of the specified column as a Date.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetDateTime()
|
inlinenodiscard |
Gets the value of the specified column as a DateTime.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetDBAnsiString()
|
inlinenodiscard |
Gets the value of the specified column as a DBAnsiString.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBBinary()
|
inlinenodiscard |
Gets the value of the specified column as a DBBinary.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBBoolean()
|
inlinenodiscard |
Gets the value of the specified column as a DBBoolean.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBByte()
|
inlinenodiscard |
Gets the value of the specified column as a DBByte.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBCurrency()
|
inlinenodiscard |
Gets the value of the specified column as a DBCurrency.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBDate()
|
inlinenodiscard |
Gets the value of the specified column as a DBDate.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBDateTime()
|
inlinenodiscard |
Gets the value of the specified column as a DBDateTime.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBDecimal()
|
inlinenodiscard |
Gets the value of the specified column as a DBDecimal.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBDouble()
|
inlinenodiscard |
Gets the value of the specified column as a DBDouble.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBGuid()
|
inlinenodiscard |
Gets the value of the specified column as a DBGuid.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBInt16()
|
inlinenodiscard |
Gets the value of the specified column as a DBInt16.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBInt32()
|
inlinenodiscard |
Gets the value of the specified column as a DBInt32.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBInt64()
|
inlinenodiscard |
Gets the value of the specified column as a DBInt64.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBNumeric()
|
inlinenodiscard |
Gets the value of the specified column as a std::optional<Numeric>.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBRowVersion()
|
inlinenodiscard |
Gets the value of the specified column as a std::optional<RowVersion>.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBSByte()
|
inlinenodiscard |
Gets the value of the specified column as a DBSByte.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBSingle()
|
inlinenodiscard |
Gets the value of the specified column as a DBSingle.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBTime()
|
inlinenodiscard |
Gets the value of the specified column as a DBTime.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBTimeSpan()
|
inlinenodiscard |
Gets the value of the specified column as a DBTimeSpan.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBTimeStampOffset()
|
inlinenodiscard |
Gets the value of the specified column as a DBTimestampOffset.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBUInt16()
|
inlinenodiscard |
Gets the value of the specified column as a DBUInt16.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBUInt32()
|
inlinenodiscard |
Gets the value of the specified column as a DBUInt32.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBUInt64()
|
inlinenodiscard |
Gets the value of the specified column as a DBUInt64.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDBWideString()
|
inlinenodiscard |
Gets the value of the specified column as a DBWideString.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
◆ GetDecimal()
|
inlinenodiscard |
Gets the value of the specified column as a Numeric.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetDescriptorAttribute()
|
inline |
Retrieves the current setting of a descriptor valued statement attribute.
- Parameters
-
attributeId Identifier of the attribute to retrieve.
- Returns
- The value of the attribute.
◆ GetDouble()
|
inlinenodiscard |
Gets the value of the specified column as a double.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetEnumAttribute()
|
inline |
Retrieves the current setting of a UInt64 valued statement attribute as an enum value.
- Parameters
-
attributeId Identifier of the attribute to retrieve.
- Returns
- The value of the attribute.
◆ GetGuid()
|
inlinenodiscard |
Gets the value of the specified column as a Guid.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetInt16()
|
inlinenodiscard |
Gets the value of the specified column as an Int16.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetInt32()
|
inlinenodiscard |
Gets the value of the specified column as an Int32.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetInt64()
|
inlinenodiscard |
Gets the value of the specified column as an Int64.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetInt64Attribute()
|
inline |
Retrieves the current setting of a Int64 valued statement attribute.
- Parameters
-
attributeId Identifier of the attribute to retrieve.
- Returns
- The value of the attribute.
◆ GetInt64ColumnAttribute()
|
inline |
◆ GetNumeric()
|
inlinenodiscard |
Gets the value of the specified column as a Numeric.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetPointerAttribute()
|
inline |
Retrieves the current setting of a pointer valued statement attribute.
- Parameters
-
attributeId Identifier of the attribute to retrieve.
- Returns
- The value of the attribute.
◆ GetRowVersion()
|
inlinenodiscard |
Gets the value of the specified column as a RowVersion.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetSByte()
|
inlinenodiscard |
Gets the value of the specified column as a SByte.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetSingle()
|
inlinenodiscard |
Gets the value of the specified column as a float.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetTime()
|
inlinenodiscard |
Gets the value of the specified column as a Time.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetTimeSpan()
|
inlinenodiscard |
Gets the value of the specified column as a TimeSpan.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetTimeStampOffset()
|
inlinenodiscard |
Gets the value of the specified column as a TimestampOffset.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetTypeInfoA()
|
inline |
◆ GetTypeInfoW()
|
inline |
◆ GetUInt16()
|
inlinenodiscard |
Gets the value of the specified column as an UInt16.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetUInt32()
|
inlinenodiscard |
Gets the value of the specified column as an UInt32.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetUInt64()
|
inlinenodiscard |
Gets the value of the specified column as an UInt64.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetUInt64Attribute()
|
inline |
Retrieves the current setting of a UInt64 valued statement attribute.
- Parameters
-
attributeId Identifier of the attribute to retrieve.
- Returns
- The value of the attribute.
◆ GetWideString()
|
inlinenodiscard |
Gets the value of the specified column as a WideString.
- Parameters
-
columnNumber The one-based column ordinal.
- Returns
- The value of the column.
The implementation throws an exception if the column value is NULL.
◆ GetWideStringColumnAttribute()
|
inline |
◆ ImplementationParameterDescriptor()
|
inline |
◆ ImplementationRowDescriptor()
|
inline |
◆ KeysetSize()
|
inline |
◆ MaxColumnLength()
|
inline |
◆ MaxRows()
|
inline |
◆ MetadataIdentifiers()
|
inline |
◆ MoreResults()
|
inline |
◆ NoScan()
|
inline |
◆ NumParams() [1/2]
|
inline |
◆ NumParams() [2/2]
|
inline |
◆ NumResultCols()
|
inline |
◆ ParamData()
|
inline |
◆ ParameterArraySize()
|
inline |
◆ ParameterBindByColumn()
|
inline |
◆ ParameterBindOffsetPointer()
|
inline |
◆ ParameterOperationPointer()
|
inline |
◆ ParameterRowSize()
|
inline |
◆ ParameterSetSize()
|
inline |
◆ ParametersProcessedPointer()
|
inline |
◆ ParameterStatusArray()
|
inline |
◆ Prepare() [1/2]
|
inline |
◆ Prepare() [2/2]
|
inline |
◆ PrimaryKeys() [1/2]
|
inline |
◆ PrimaryKeys() [2/2]
|
inline |
◆ ProcedureColumns() [1/2]
|
inline |
◆ ProcedureColumns() [2/2]
|
inline |
◆ Procedures() [1/2]
|
inline |
◆ Procedures() [2/2]
|
inline |
◆ PutData()
|
inline |
◆ QueryTimeout()
|
inline |
◆ ResetParameters()
|
inline |
Sets the SQL_DESC_COUNT field of the APD to 0, releasing all parameter buffers set by BindParameter for the statement.
If this operation is performed on an explicitly allocated descriptor that is shared by more than one statement, this operation will affect the bindings of all the statements that share the descriptor.
◆ RetrieveData()
|
inline |
◆ RowArraySize()
|
inline |
◆ RowBindByColumn()
|
inline |
◆ RowBindOffsetPointer()
|
inline |
◆ RowCount() [1/2]
|
inline |
◆ RowCount() [2/2]
|
inline |
◆ RowNumber()
|
inline |
◆ RowOperationPointer()
|
inline |
◆ RowsFetchedPointer()
|
inline |
◆ RowSize()
|
inline |
◆ RowStatusPointer()
|
inline |
◆ SetApplicationParameterDescriptor() [1/2]
|
inline |
Sets the handle to the APD for subsequent calls to SQLExecute and SQLExecDirect on the statement handle. The initial value of this attribute is the descriptor implicitly allocated when the statement was initially allocated. If the value of this attribute is set to SQL_NULL_DESC or the handle originally allocated for the descriptor, an explicitly allocated APD handle that was previously associated with the statement handle is dissociated from it and the statement handle reverts to the implicitly allocated APD handle.
This attribute cannot be set to a descriptor handle that was implicitly allocated for another statement or to another descriptor handle that was implicitly set on the same statement; implicitly allocated descriptor handles cannot be associated with more than one statement or descriptor handle.
- Parameters
-
applicationParameterDescriptor The application parameter descriptor
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetApplicationParameterDescriptor() [2/2]
|
inline |
◆ SetApplicationRowDescriptor() [1/2]
|
inline |
Sets the handle to the ARD for subsequent fetches on the statement handle. The initial value of this attribute is the descriptor implicitly allocated when the statement was initially allocated. If the value of this attribute is set to SQL_NULL_DESC or the handle originally allocated for the descriptor, an explicitly allocated ARD handle that was previously associated with the statement handle is dissociated from it and the statement handle reverts to the implicitly allocated ARD handle.
This attribute cannot be set to a descriptor handle that was implicitly allocated for another statement or to another descriptor handle that was implicitly set on the same statement; implicitly allocated descriptor handles cannot be associated with more than one statement or descriptor handle.
- Parameters
-
applicationRowDescriptor The application row descriptor
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetApplicationRowDescriptor() [2/2]
|
inline |
◆ SetAsyncEnabled()
|
inline |
Enables or disables asynchronous statement execution.
- Parameters
-
asyncEnable true to enable asynchronous statement execution, otherwise false.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetAsyncEventHandle() [1/2]
|
inline |
Assigns the Windows event handle that will get notified on asynchronous completion.
- Parameters
-
asyncEventHandle A windows event handle.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetAsyncEventHandle() [2/2]
|
inline |
Assigns the Windows event handle that will get notified on asynchronous completion.
- Parameters
-
asyncEventHandle A windows event handle.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetAttributeA()
|
inline |
Sets attributes related to a statement.
- Parameters
-
attributeId Identifier of the attribute to set. value Value to be associated with the attribute. Depending on the value of attributeId, value will be one of the following: - An ODBC descriptor handle.
- A SQLUINTEGER value.
- A SQLULEN value.
-
A pointer to one of the following:
- A null-terminated character string.
- A binary buffer.
- A value or array of type SQLLEN, SQLULEN, or SQLUSMALLINT.
- A driver-defined value.
valueLength If attributeId is an ODBC-defined attribute and value points to a character string or a binary buffer, this argument should be the length of value. If attributeId is an ODBC-defined attribute and valuePtr is an integer, valueLength is ignored. If attributeId is a driver-defined attribute, the application indicates the nature of the attribute to the Driver Manager by setting the valueLength argument. valueLength can have the following values: - If value is a pointer to a character string, then valueLength is the length of the string or SQL_NTS.
- If value is a pointer to a binary buffer, then the application places the result of the SQL_LEN_BINARY_ATTR(length) macro in valueLength. This places a negative value in valueLength.
- If value is a pointer to a value other than a character string or a binary string, then valueLength should have the value SQL_IS_POINTER.
- If value contains a fixed-length value, then valueLength is either SQL_IS_INTEGER or SQL_IS_UINTEGER, as appropriate.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetAttributeW()
|
inline |
Sets attributes related to a statement.
- Parameters
-
attributeId Identifier of the attribute to set. value Value to be associated with the attribute. Depending on the value of attributeId, value will be one of the following: - An ODBC descriptor handle.
- A SQLUINTEGER value.
- A SQLULEN value.
-
A pointer to one of the following:
- A null-terminated character string.
- A binary buffer.
- A value or array of type SQLLEN, SQLULEN, or SQLUSMALLINT.
- A driver-defined value.
valueLength If attributeId is an ODBC-defined attribute and value points to a character string or a binary buffer, this argument should be the length of value. If attributeId is an ODBC-defined attribute and valuePtr is an integer, valueLength is ignored. If attributeId is a driver-defined attribute, the application indicates the nature of the attribute to the Driver Manager by setting the valueLength argument. valueLength can have the following values: - If value is a pointer to a character string, then valueLength is the length of the string or SQL_NTS.
- If value is a pointer to a binary buffer, then the application places the result of the SQL_LEN_BINARY_ATTR(length) macro in valueLength. This places a negative value in valueLength.
- If value is a pointer to a value other than a character string or a binary string, then valueLength should have the value SQL_IS_POINTER.
- If value contains a fixed-length value, then valueLength is either SQL_IS_INTEGER or SQL_IS_UINTEGER, as appropriate.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetAutoPopulateImplementationParameterDescriptor()
|
inline |
◆ SetBooleanAttribute()
|
inline |
Sets an boolean valued attribute.
- Parameters
-
attributeId Identifier of the attribute to set. value The value to assign to the attribute.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetConcurrency()
|
inline |
Assigns the cursor concurrency model to be used with the statement.
- Parameters
-
concurrency
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetCursorName() [1/2]
|
inline |
◆ SetCursorName() [2/2]
|
inline |
◆ SetCursorScrollable()
|
inline |
- Parameters
-
cursorScrollable Set to true if scrollable cursors are required on the statement handle. When calling FetchScroll, the application may specify any valid value of FetchOrientation, achieving cursor positioning in modes other than the sequential mode. Set to false if scrollable cursors are not required on the statement handle. If the application calls FetchScroll on this handle, the only valid value of FetchOrientation is FetchOrientation::Next. This is the default.
- Returns
◆ SetCursorSensitivity()
|
inline |
◆ SetCursorType()
|
inline |
◆ SetDescriptorAttribute() [1/2]
|
inline |
Sets a descriptor valued attribute.
- Parameters
-
attributeId Identifier of the attribute to set. value The value to assign to the attribute.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetDescriptorAttribute() [2/2]
|
inline |
Sets a descriptor valued attribute.
- Parameters
-
attributeId Identifier of the attribute to set. value The value to assign to the attribute.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetEnumAttribute()
Sets an UInt64 valued attribute valued attribute to the value from an enumeration.
- Parameters
-
attributeId Identifier of the attribute to set. value The value to assign to the attribute.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetInt64Attribute()
|
inline |
Sets an Int64 valued attribute.
- Parameters
-
attributeId Identifier of the attribute to set. value The value to assign to the attribute.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetKeysetSize()
|
inline |
◆ SetMaxColumnLength()
|
inline |
◆ SetMaxRows()
|
inline |
◆ SetMetadataIdentifiers()
|
inline |
◆ SetNoScan()
|
inline |
◆ SetParameterArraySize()
◆ SetParameterBindByColumn()
|
inline |
◆ SetParameterBindOffsetPointer()
|
inline |
◆ SetParameterOperationPointer()
|
inline |
◆ SetParameterRowSize()
|
inline |
◆ SetParameterSetSize()
|
inline |
◆ SetParametersProcessedPointer()
|
inline |
◆ SetParameterStatusArray()
|
inline |
◆ SetPointerAttribute()
|
inline |
Sets an pointer valued attribute.
- Parameters
-
attributeId Identifier of the attribute to set. value The value to assign to the attribute.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetPosition()
|
inline |
◆ SetQueryTimeout() [1/2]
◆ SetQueryTimeout() [2/2]
◆ SetRetrieveData()
|
inline |
◆ SetRowArraySize()
◆ SetRowBindByColumn()
|
inline |
◆ SetRowBindOffsetPointer()
|
inline |
◆ SetRowOperationPointer()
|
inline |
◆ SetRowsFetchedPointer()
|
inline |
◆ SetRowSize()
|
inline |
◆ SetRowStatusPointer()
|
inline |
◆ SetSimulateCursor()
|
inline |
◆ SetUInt64Attribute()
|
inline |
Sets an UInt64 valued attribute.
- Parameters
-
attributeId Identifier of the attribute to set. value The value to assign to the attribute.
- Returns
- Result::Success or Result::SuccessWithInfo
◆ SetUseBookmarks()
|
inline |
◆ SimulateCursor()
|
inline |
◆ SpecialColumns() [1/2]
|
inline |
◆ SpecialColumns() [2/2]
|
inline |
◆ Statistics() [1/2]
|
inline |
◆ Statistics() [2/2]
|
inline |
◆ TablePrivileges() [1/2]
|
inline |
◆ TablePrivileges() [2/2]
|
inline |
◆ Tables() [1/2]
|
inline |
◆ Tables() [2/2]
|
inline |
◆ Unbind()
|
inline |
Sets the SQL_DESC_COUNT field of the ARD to 0, releasing all column buffers bound by BindColumn for the statement.
This does not unbind the bookmark column; to do that, the SQL_DESC_DATA_PTR field of the ARD for the bookmark column is set to NULL. Notice that if this operation is performed on an explicitly allocated descriptor that is shared by more than one statement, the operation will affect the bindings of all statements that share the descriptor.
◆ UseBookmarks()
|
inline |
Friends And Related Symbol Documentation
◆ Connection
|
friend |
The documentation for this class was generated from the following file:
- C:/Src/Harlinn.Windows/Harlinn.ODBC/HODBC.h
