executeDeleteTop<T> method

Future<SQLResponseOf<void>> executeDeleteTop<T>({
  1. required String tableName,
  2. required int count,
  3. required String idColumn,
  4. required bool asc,
  5. JsonRow where = const {},
  6. bool nullAsBlank = false,
})

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

The tableName parameter specifies the name of the table to delete from. The count parameter specifies the number of rows to delete. The idColumn parameter specifies the column to order by. The asc parameter specifies whether to order in ascending or descending order. 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>> executeDeleteTop<T>({required String tableName, required int count, required String idColumn, required bool asc, JsonRow where = const {}, bool nullAsBlank = false}) {
  return executeSQL(
      dataSetType: "value",
      sql: where.asDeleteTopCommand(
        tableName,
        count,
        idColumn,
        asc,
        dataBaseProvider,
        nullAsBlank,
        quoteChar,
      ));
}