Binds given string values to parameter marker in prepared statement. More...

Collaboration diagram for Binding multiple string values:

Functions
template<class T , typename = enable_if_character<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, T const *values, std::size_t value_size, std::size_t batch_size)
	Binds multiple string values.

template<class T , typename = enable_if_string<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, std::vector< T > const &values)
	Binds multiple string values.

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, T const (&values)[BatchSize][ValueSize])
	Binds multiple string values.

template<class T , typename = enable_if_character<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, T const values, std::size_t value_size, std::size_t batch_size, T const null_sentry)
	Binds multiple string values.

template<class T , typename = enable_if_string<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, std::vector< T > const &values, typename T::value_type const *null_sentry)
	Binds multiple string values.

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, T const (&values)[BatchSize][ValueSize], T const *null_sentry)
	Binds multiple string values.

template<class T , typename = enable_if_character<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, T const values, std::size_t value_size, std::size_t batch_size, bool const nulls)
	Binds multiple string values.

template<class T , typename = enable_if_string<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, std::vector< T > const &values, bool const *nulls)
	Binds multiple string values.

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>
void	nanodbc::table_valued_parameter::bind_strings (short param_index, T const (&values)[BatchSize][ValueSize], bool const *nulls)
	Binds multiple string values.

template<class T , typename = enable_if_character<T>>
void	nanodbc::statement::bind_strings (short param_index, T const *values, std::size_t value_size, std::size_t batch_size, param_direction direction=PARAM_IN)
	Binds multiple string values.

template<class T , typename = enable_if_string<T>>
void	nanodbc::statement::bind_strings (short param_index, std::vector< T > const &values, param_direction direction=PARAM_IN)
	Binds multiple string values.

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>
void	nanodbc::statement::bind_strings (short param_index, T const (&values)[BatchSize][ValueSize], param_direction direction=PARAM_IN)
	Binds multiple string values.

template<class T , typename = enable_if_character<T>>
void	nanodbc::statement::bind_strings (short param_index, T const values, std::size_t value_size, std::size_t batch_size, T const null_sentry, param_direction direction=PARAM_IN)
	Binds multiple string values.

template<class T , typename = enable_if_string<T>>
void	nanodbc::statement::bind_strings (short param_index, std::vector< T > const &values, typename T::value_type const *null_sentry, param_direction direction=PARAM_IN)
	Binds multiple string values.

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>
void	nanodbc::statement::bind_strings (short param_index, T const (&values)[BatchSize][ValueSize], T const *null_sentry, param_direction direction=PARAM_IN)
	Binds multiple string values.

template<class T , typename = enable_if_character<T>>
void	nanodbc::statement::bind_strings (short param_index, T const values, std::size_t value_size, std::size_t batch_size, bool const nulls, param_direction direction=PARAM_IN)
	Binds multiple string values.

template<class T , typename = enable_if_string<T>>
void	nanodbc::statement::bind_strings (short param_index, std::vector< T > const &values, bool const *nulls, param_direction direction=PARAM_IN)
	Binds multiple string values.

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>
void	nanodbc::statement::bind_strings (short param_index, T const (&values)[BatchSize][ValueSize], bool const *nulls, param_direction direction=PARAM_IN)
	Binds multiple string values.

Detailed Description

Binds given string values to parameter marker in 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	Array of values to substitute into parameter placeholders.
value_size	Maximum length of string value in array.
batch_size	Number of string values to bind. Otherwise template parameter BatchSize is taken as the number of values. 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.

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	Array of values to substitute into parameter placeholders.
value_size	Maximum length of string value in array.
batch_size	Number of string values to bind. Otherwise template parameter BatchSize is taken as the number of values.
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_strings() [1/18]

template<class T , typename = enable_if_character<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [2/18]

template<class T , typename = enable_if_string<T>>

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

Binds multiple string values.

Size of the values vector indicates number of values to bind. Longest string in the array determines maximum length of individual value.

See also: bind_strings

◆ bind_strings() [3/18]

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>

void nanodbc::table_valued_parameter::bind_strings	(	short	param_index,
		T const (&)	values[BatchSize][ValueSize]
	)

inline

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [4/18]

template<class T , typename = enable_if_character<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [5/18]

template<class T , typename = enable_if_string<T>>

void nanodbc::table_valued_parameter::bind_strings	(	short	param_index,
		std::vector< T > const &	values,
		typename T::value_type const *	null_sentry
	)

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [6/18]

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>

void nanodbc::table_valued_parameter::bind_strings	(	short	param_index,
		T const (&)	values[BatchSize][ValueSize],
		T const *	null_sentry
	)

inline

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [7/18]

template<class T , typename = enable_if_character<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [8/18]

template<class T , typename = enable_if_string<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [9/18]

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>

void nanodbc::table_valued_parameter::bind_strings	(	short	param_index,
		T const (&)	values[BatchSize][ValueSize],
		bool const *	nulls
	)

inline

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [10/18]

template<class T , typename = enable_if_character<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [11/18]

template<class T , typename = enable_if_string<T>>

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

Binds multiple string values.

Size of the values vector indicates number of values to bind. Longest string in the array determines maximum length of individual value.

See also: bind_strings

◆ bind_strings() [12/18]

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>

void nanodbc::statement::bind_strings	(	short	param_index,
		T const (&)	values[BatchSize][ValueSize],
		param_direction	direction = `PARAM_IN`
	)

inline

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [13/18]

template<class T , typename = enable_if_character<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [14/18]

template<class T , typename = enable_if_string<T>>

void nanodbc::statement::bind_strings	(	short	param_index,
		std::vector< T > const &	values,
		typename T::value_type const *	null_sentry,
		param_direction	direction = `PARAM_IN`
	)

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [15/18]

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>

void nanodbc::statement::bind_strings	(	short	param_index,
		T const (&)	values[BatchSize][ValueSize],
		T const *	null_sentry,
		param_direction	direction = `PARAM_IN`
	)

inline

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [16/18]

template<class T , typename = enable_if_character<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [17/18]

template<class T , typename = enable_if_string<T>>

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

Binds multiple string values.

See also: bind_strings

◆ bind_strings() [18/18]

template<std::size_t BatchSize, std::size_t ValueSize, class T , typename = enable_if_character<T>>

void nanodbc::statement::bind_strings	(	short	param_index,
		T const (&)	values[BatchSize][ValueSize],
		bool const *	nulls,
		param_direction	direction = `PARAM_IN`
	)

inline

Binds multiple string values.

See also: bind_strings

Functions

Detailed Description

Function Documentation

◆ bind_strings() [1/18]

◆ bind_strings() [2/18]

◆ bind_strings() [3/18]

◆ bind_strings() [4/18]

◆ bind_strings() [5/18]

◆ bind_strings() [6/18]

◆ bind_strings() [7/18]

◆ bind_strings() [8/18]

◆ bind_strings() [9/18]

◆ bind_strings() [10/18]

◆ bind_strings() [11/18]

◆ bind_strings() [12/18]

◆ bind_strings() [13/18]

◆ bind_strings() [14/18]

◆ bind_strings() [15/18]

◆ bind_strings() [16/18]

◆ bind_strings() [17/18]

◆ bind_strings() [18/18]