exec method

Future<int> exec(
  1. String sql, {
  2. Map<String, dynamic>? params,
})

Runs an INSERT / UPDATE / DELETE (an id-less ExecSQL). Returns the number of affected rows.

Implementation

Future<int> exec(String sql, {Map<String, dynamic>? params}) async {
  final sqlToRun = (params == null) ? expandSql(sql) : sql;
  final q = TSQLQuery();
  q.database = connection;
  _applySqlAndParams(q, sqlToRun, params);
  return await q.execSQLAsync();
}