Prepared.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 stmt = conn.prepare("INSERT INTO `table42` VALUES(?, ?, ?)");
DataRecord dr;    // Some data input facility
ulong ra;
do
{
    dr.get();
    stmt.setArgs(dr("Name"), dr("City"), dr("Whatever"));
    ulong rowsAffected = stmt.exec();
} while(!dr.done);