Statement.bind - multiple declarations

Function Statement.bind

Binds values to parameters of this statement, using parameter index.

void bind(T) (
  int index,
  T value
);

Parameters

NameDescription
index The index of the parameter (starting from 1).
value The bound value. The type of value must be compatible with the SQLite

types

it must be a boolean or numeric type, a string, an array, null, or a Nullable!T where T is any of the previous types.

Function Statement.bind

Binds values to parameters of this statement, using parameter names.

void bind(T) (
  string name,
  T value
);

Parameters

NameDescription
name The name of the parameter, including the ':', '@' or '$' that introduced it.
value The bound value. The type of value must be compatible with the SQLite

types

it must be a boolean or numeric type, a string, an array, null, or a Nullable!T where T is any of the previous types.

Warning

While convenient, this overload of bind is less performant, because it has to retrieve the column index with a call to the SQLite function sqlite3_bind_parameter_index.