Learn R Programming

DBItest (version 1.8.2)

spec_meta_get_rows_affected: spec_meta_get_rows_affected

Description

spec_meta_get_rows_affected

Arguments

Value

dbGetRowsAffected() returns a scalar number (integer or numeric), the number of rows affected by a data manipulation statement issued with DBI::dbSendStatement(). The value is available directly after the call and does not change after calling DBI::dbFetch(). NA_integer_ or NA_numeric_ are allowed if the number of rows affected is not known.

For queries issued with DBI::dbSendQuery(), zero is returned before and after the call to dbFetch(). NA values are not allowed.

Failure modes

Attempting to get the rows affected for a result set cleared with DBI::dbClearResult() gives an error.

See Also

Other meta specifications: spec_get_info, spec_meta_bind, spec_meta_column_info, spec_meta_get_row_count, spec_meta_get_statement, spec_meta_has_completed, spec_meta_is_valid