executeUpdate method

Future<SQLResponseOf<void>> executeUpdate({
  1. required String tableName,
  2. required JsonRow values,
  3. required JsonRow where,
  4. bool nullAsBlank = false,
})

Executes an SQL UPDATE query and returns the result as a SQLResponseOf object.

The tableName parameter specifies the name of the table to update. The values parameter is a JsonRow object representing the new values. The where parameter is a JsonRow object representing the WHERE clause. The nullAsBlank parameter specifies whether to treat null values as blank.

Implementation

Future<SQLResponseOf<void>> executeUpdate({required String tableName, required JsonRow values, required JsonRow where, bool nullAsBlank = false}) {
  return executeSQL(
    dataSetType: "table",
    sql: values.asUpdateCommand(
      tableName: tableName,
      where: where,
      nullAsBlank: nullAsBlank,
      quoteChar: quoteChar,
      dataBaseProvider: dataBaseProvider,
    ),
  );
}