Binding multiple non-string values

Binds given values to given parameter placeholder number in the prepared statement. More...

Collaboration diagram for Binding multiple non-string values:

Functions
template<class T >
void	nanodbc::table_valued_parameter::bind (short param_index, T const *values, std::size_t batch_size)
	Binds multiple values.
template<class T >
void	nanodbc::table_valued_parameter::bind (short param_index, T const *values, std::size_t batch_size, T const *null_sentry)
	Binds multiple values.
template<class T >
void	nanodbc::table_valued_parameter::bind (short param_index, T const *values, std::size_t batch_size, bool const *nulls)
	Binds multiple values.
void	nanodbc::table_valued_parameter::bind (short param_index, std::vector< std::vector< uint8_t > > const &values)
	Binds multiple values.
void	nanodbc::table_valued_parameter::bind (short param_index, std::vector< std::vector< uint8_t > > const &values, bool const *nulls)
	Binds multiple values.
void	nanodbc::table_valued_parameter::bind (short param_index, std::vector< std::vector< uint8_t > > const &values, uint8_t const *null_sentry)
	Binds multiple values.
template<class T >
void	nanodbc::statement::bind (short param_index, T const *values, std::size_t batch_size, param_direction direction=PARAM_IN)
	Binds multiple values.
template<class T >
void	nanodbc::statement::bind (short param_index, T const *values, std::size_t batch_size, T const *null_sentry, param_direction direction=PARAM_IN)
	Binds multiple values.
template<class T >
void	nanodbc::statement::bind (short param_index, T const *values, std::size_t batch_size, bool const *nulls, param_direction direction=PARAM_IN)
	Binds multiple values.
void	nanodbc::statement::bind (short param_index, std::vector< std::vector< uint8_t > > const &values, param_direction direction=PARAM_IN)
	Binds multiple values.
void	nanodbc::statement::bind (short param_index, std::vector< std::vector< uint8_t > > const &values, bool const *nulls, param_direction direction=PARAM_IN)
	Binds multiple values.
void	nanodbc::statement::bind (short param_index, std::vector< std::vector< uint8_t > > const &values, uint8_t const *null_sentry, param_direction direction=PARAM_IN)
	Binds multiple values.

Detailed Description

Binds given values to given parameter placeholder number in the prepared statement.

If your prepared SQL query has any parameter markers, ? (question mark) placeholders, this is how you bind values to them. Parameter markers are numbered using Zero-based index from left to right.

It is possible to use these functions for batch operations.

Parameters

param_index	Zero-based index of parameter marker (placeholder position).
values	Values to substitute into placeholder.
batch_size	The number of values being bound. batch_size should greater or equal than row_count
null_sentry	Value which should represent a null value.
nulls	Flags for values that should be set to a null value.
param_direction	ODBC parameter direction.

Exceptions

database_error

If your prepared SQL query has any parameter markers, ? (question mark) placeholders, this is how you bind values to them. Parameter markers are numbered using Zero-based index from left to right.

It is possible to use these functions for batch operations.

Parameters

param_index	Zero-based index of parameter marker (placeholder position).
values	Values to substitute into placeholder.
batch_size	The number of values being bound.
null_sentry	Value which should represent a null value.
nulls	Flags for values that should be set to a null value.
param_direction	ODBC parameter direction.

Exceptions

database_error

Function Documentation

bind() [1/12]

template<class T >

void nanodbc::table_valued_parameter::bind	(	short	param_index,
		T const *	values,
		std::size_t	batch_size
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [2/12]

template<class T >

void nanodbc::table_valued_parameter::bind	(	short	param_index,
		T const *	values,
		std::size_t	batch_size,
		T const *	null_sentry
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [3/12]

template<class T >

void nanodbc::table_valued_parameter::bind	(	short	param_index,
		T const *	values,
		std::size_t	batch_size,
		bool const *	nulls
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [4/12]

void nanodbc::table_valued_parameter::bind	(	short	param_index,
		std::vector< std::vector< uint8_t > > const &	values
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [5/12]

void nanodbc::table_valued_parameter::bind	(	short	param_index,
		std::vector< std::vector< uint8_t > > const &	values,
		bool const *	nulls
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [6/12]

void nanodbc::table_valued_parameter::bind	(	short	param_index,
		std::vector< std::vector< uint8_t > > const &	values,
		uint8_t const *	null_sentry
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [7/12]

template<class T >

void nanodbc::statement::bind	(	short	param_index,
		T const *	values,
		std::size_t	batch_size,
		param_direction	direction = PARAM_IN
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [8/12]

template<class T >

void nanodbc::statement::bind	(	short	param_index,
		T const *	values,
		std::size_t	batch_size,
		T const *	null_sentry,
		param_direction	direction = PARAM_IN
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [9/12]

template<class T >

void nanodbc::statement::bind	(	short	param_index,
		T const *	values,
		std::size_t	batch_size,
		bool const *	nulls,
		param_direction	direction = PARAM_IN
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [10/12]

void nanodbc::statement::bind	(	short	param_index,
		std::vector< std::vector< uint8_t > > const &	values,
		param_direction	direction = PARAM_IN
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [11/12]

void nanodbc::statement::bind	(	short	param_index,
		std::vector< std::vector< uint8_t > > const &	values,
		bool const *	nulls,
		param_direction	direction = PARAM_IN
	)

Binds multiple values.

See also

Binding multiple non-string values

bind() [12/12]

void nanodbc::statement::bind	(	short	param_index,
		std::vector< std::vector< uint8_t > > const &	values,
		uint8_t const *	null_sentry,
		param_direction	direction = PARAM_IN
	)

Binds multiple values.

See also

Binding multiple non-string values