PreparedImpl.setArgs - multiple declarations

Function PreparedImpl.setArgs

Bind a tuple of D variables to the parameters of a prepared statement.

You can use this method to bind a set of variables if you don't need any specialization, that is chunked transfer is not neccessary.

The tuple must match the required number of parameters, and it is the programmer's responsibility to ensure that they are of appropriate types.

Prototype

void setArgs(T...)(
  T args
)
if (T.length == 0 || !is(T[0] == Variant[]));

Function PreparedImpl.setArgs

Bind a Variant[] as the parameters of a prepared statement.

You can use this method to bind a set of variables in Variant form to the parameters of a prepared statement.

Parameter specializations can be added if required. This method could be used to add records from a data entry form along the lines of 

auto c = Command(con, "insert into table42 values(?, ?, ?)");
c.prepare();
Variant[] va;
va.length = 3;
DataRecord dr;    // Some data input facility
ulong ra;
do
{
    dr.get();
    va[0] = dr("Name");
    va[1] = dr("City");
    va[2] = dr("Whatever");
    c.bindParameters(va);
    c.execPrepared(ra);
} while(tod < "17:30");

Prototype

void setArgs(
  std.variant.VariantN!(32L)[] va,
  ParameterSpecialization[] psnList = null
);

Parameters

NameDescription
va External list of Variants to be used as parameters
psnList any required specializations

Authors

Copyright

License